If logic

  • Thread starter Thread starter Dan
  • Start date Start date
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?
 
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.
 
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.
 
Back
Top