late count

  • Thread starter Thread starter rob p
  • Start date Start date
R

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.
 
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]
 
Back
Top