Showing $0.00 in Query

[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.

 

[fredg]

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.

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