Need count in footer but no detail in report

M

mscertified

I have a report that needs to print detail for unresolved items and in the
footer a count for closed and unresolved items. I need to print the count of
closed items even if there are no unresolved items. So I need the closed and
unresolved items in my report query but somehow must only print detail for
unresolved items. How to do this?
 
D

Duane Hookom

You might be able to add code to the On Format section of your report like:
Cancel = (Me.txtClosed = somevalue)
 
Top