How can I count records in a report ?

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I have a report that gives detail of transactions line by line, one
transaction on one line. I need to put a total in the report footer for the
number of transactions (ie the number of lines) in the report. Is there a
COUNT function somewhere which I can put in a text box in the report footer
? I can't find it ? I am using Access2002sp3

thanks .... Roger
 
Sure. Put a text box in the Report Footer section, and set its Control
Source to:
=Count("*")
 
Back
Top