Count records

[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

 

[Allen Browne]

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")

 

[Tom]

Many thanks Allen - the 1st worked a treat - the 2nd showed 0 records but 6
were shown in the report

tom