If logic

D

Dan

i have a field on a report that in most cases that data is
0 (this is a numeric field) i dont want to see 0 on my
report, i only want to see the number if it is greater
than 0 is there some if logic i can use in the report?
 
M

Marshall Barton

Dan said:
i have a field on a report that in most cases that data is
0 (this is a numeric field) i dont want to see 0 on my
report, i only want to see the number if it is greater
than 0 is there some if logic i can use in the report?
Click to expand...


You don't need any logic. This is just a formatting issue.

Use a custom format in the text box. What the format would
be depends on the data field's data type. For an integer
type is could be:

#,##0;;

See the Format Property in Help for all of the available
formatting codes.
 
F

fredg

i have a field on a report that in most cases that data is
0 (this is a numeric field) i dont want to see 0 on my
report, i only want to see the number if it is greater
than 0 is there some if logic i can use in the report?
Click to expand...

Greater than zero also means no negative amounts, correct?

Set the format property of this control to:
#;""

Look up the Format Property + Number and Currency Datatypes
in Access Help.
 
Top