Need count in footer but no detail in report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mscertified - 28 Feb 2005 17:09 GMT

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?

Reply to this Message

Duane Hookom - 28 Feb 2005 21:54 GMT

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

Signature

Duane Hookom
MS Access MVP
--

>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
[quoted text clipped - 3 lines]
> unresolved items in my report query but somehow must only print detail for
> unresolved items. How to do this?

Reply to this Message