I created a report in Q3, and reading a number in from a field, what I would like to do is format the number like this
if the number is > then 8 digits, format it like this ### ### ###
if it is <= 8 digits format it like this #### ####
how would I do this, I am new to all of this and still learning please guide me in the right direction, or maybe a video or certain page in the manual would be great.
thanks in advance
Pete
if the number is > then 8 digits, format it like this ### ### ###
if it is <= 8 digits format it like this #### ####
how would I do this, I am new to all of this and still learning please guide me in the right direction, or maybe a video or certain page in the manual would be great.
thanks in advance
Pete