Showing $0.00 in Query

  • Thread starter Thread starter DBarker
  • Start date Start date
D

DBarker

I have a report that is based on a query. I need it to
show the $0.00 when they apply to compare against the
other field on the report. Any help would be appreciated.
 
I have a report that is based on a query. I need it to
show the $0.00 when they apply to compare against the
other field on the report. Any help would be appreciated.
Click to expand...

You haven't told us what the other values should look like!!!

Set the Format property of the control (in the Report), to:
$#,##0.00;-$#,##0.00;$0.00

$1,234.15 -$1234.15 $0.00

See Access Help files on
format + number and currency datatypes
 
Back
Top