total # of records in a report

[burger54]

is there a simple way to attach the total number of records in a report to a text box on the report? I tried using the count function in the expression builder, but it returns the number 70 even thought there are only 2 records. I am using access 2000.
Thanks in advance

[maxamis4]

Need more info but as long as you enter count([variable in your report]) in the group footer than it should count.

[ADezii]

is there a simple way to attach the total number of records in a report to a text box on the report? I tried using the count function in the expression builder, but it returns the number 70 even thought there are only 2 records. I am using access 2000.
Thanks in advance

If the Record Source for your Report is a 'Table' or 'Stored Query', place the following Expression in the Control Source Property for a Text Box placed anywhere on the Report:
[CODE=vb]=DCount("*", "<Record Source of Report>")[/CODE]