late count

[rob p]

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.

 

[Wayne Morgan]

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]