COUNT FILTERED REPORTS RECORDS

[Guest]

hi, im trying to display number of records in my filtered report.

when i tried my code in a FORM, it worked:

Me.RecordsetClone.MoveLast
xcount = Me.RecordsetClone.RecordCount
MsgBox xcount

Im trying to use t his in my REPORT but seems it doesnt work on REPORT..

any suggestions how i can count my records in filtered report..


thanks you..

amsuria

 

[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 property to:
=Count("*")

If you don't see any Report Footer section when you open your report in
design view, it's on the View menu.