Access won't print anything for a control in which the amount is zero

clmarks

Registered User.
Local time
Today, 00:09
Joined
Jan 29, 2007
Messages
69
I have a report where the report header contains a total number for each type of service that we provided. The number of services is calculated from the detail section by using DSum. The number for each type is then multiplied by the rate for that service in another control. My problem is that if the total number of a particular service is zero, nothing prints. I have even tried adding zero to the number I get from DSum.

Does anyone have a suggestion for another way to get my desired end result?

Thanks in advance for your help.
 
you can probably use

nz("yourfieldname",0)

in your report
 

Users who are viewing this thread

Back
Top Bottom