Report with grouping

E

ehale

Hello. I have a report based on a query that is gathering records with an
effective date within 2 months of current month. I'm grouping in report
based on effective date because I want to isolate the two months, e.g., if I
run query/report in August, then I need to see

Month: Sep-04
Quotes: 54
Premium: $75,551

Month: Oct-04
Quotes: 0
Premium: $0

I'm hiding the detail, as all I need to see is the totals I showed above.
The problem is that when there are no quotes with effective date 2 months
out, the group footer for the second month won't appear on the report. How
can I resolve?
 
F

Fons Ponsioen

What you could use is the NZ() function.
for instance:
=NZ(Sum([Quotes]),"0")
Hope this helps
Fons
 
Top