late count

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rob p - 08 Dec 2005 22:57 GMT

I made a report from a query. Query has a field which is longinteger. I
didn't add a counter with the wizard. How or where do I add it now? I want
to count all records and print on report footer.

I kind of remember adding in query as a new field?

thanks.

Reply to this Message

Wayne Morgan - 08 Dec 2005 23:14 GMT

Add a hidden textbox to the detail section of the report. Set its Control
Source to =1 and set its RunningSum property to Over All. In the report
footer, add a textbox that refers to the textbox you added to the detail
section.

ControlSource of textbox in report footer:
=[NameOfTextboxInDetailSection]

Signature

Wayne Morgan
MS Access MVP

>I made a report from a query. Query has a field which is longinteger. I
> didn't add a counter with the wizard. How or where do I add it now? I want
[quoted text clipped - 3 lines]
>
> thanks.

Reply to this Message