I am having a hard time figuring out why i can't get a report to a zero value as $0.00. When i create a test report with one table and a few fields. One field set to Currency and zero values, the report shows the $0.00 in the field. The report I am having trouble with is a query from a couple of tables, but the currency field is static, or not calculated in the report, the report is just showing data. I have the field in the report formatted as Currency, but it will not show $0.00 in the report when the value is zero. The report shows nothing. Any ideas please.