Unable to set Total Amount to zero for no records

[tmartin]

If you run LaunchMe, a report opens that has several subforms. The one form called New Business has no records in the database when


executing the query as expected.

I need to have the form have a value of zero dollars for no records.
I have tried adding the Nz(xxxxxx,0) to both the form and query attempting to force a value of zero by default but still always
end up with an error. I have attached an example on the New Business that will not show $0.00 for no records in the database.

I have also tried adding the Nz(xxxx,0) to the form.

Thanks
Tom

[pbaldy]

Is this relevant?

nnz function

[Dhamdard]

Conditional DCount expression can help you with it. For example:

Expenses:
=IIf(DCount("*","Daily Expen subReport")>=0,[Control Name],0)

This expression looks through the query and IF there are 1 or more records, it will display the value of the control you specify. In the control name type the name of that control. If the value is smaller or equal to zero, then the database will display 0 only.

Thanks,
Dad