Count records

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

Hi

Any advice on how to achieve the following would be appreciated.

Am setting the recordsource for a report at runtime when the report opens.

The recordsource sql is: strSQL = "SELECT qryServicesByMisc.* " & _
"FROM
qryServicesByMisc " & _
"WHERE
qryServicesByMisc.NotCurrent=0"

Would like to have a text box on that report which in which the number of
records in that sql are counted

Using Access 2003

Thanks in advance

tom
 
To display the number of records in the report, add a text box to the Report
Footer section, and set its Control Source to:
=Count("*")

Alternative:
=DCount("*", "qryServicesByMisc", "NotCurrent=0")
 
Many thanks Allen - the 1st worked a treat - the 2nd showed 0 records but 6
were shown in the report

tom
 
Back
Top