Need Zeros Removed from Report

[jc_unk]

Hey guys,

I have calculated fields on my tables and used zero values as default to show totals. But when I view my report, all the zeros appear.
Don't want those zeros to appear on the report.

 

[MSAccessRookie]

Hey guys,

I have calculated fields on my tables and used zero values as default to show totals. But when I view my report, all the zeros appear.
Don't want those zeros to appear on the report.

If you need the values, and only want to not display them, then investigate the Built-In Function IIf(). You might be able to use it to get what you want.