Display total number of records in report

[0243906]

I currently have a number have query which results in a number of records. I am then using this query to make a report. In the report is a list of all the records and small bit of information from the records. What i need is a small summary at the bottom saying something like: Number of Records returned = 'XX' number.
Currently i need to check how many records matched the query and then type this in manually into the record.
Any help would be greatly appreciated.

 

[ZmrAbdulla]

Place a textbox on the reportfooter and set it's control source to

=Count([AnyFiledName])

It's label can be captioned like you said "Number of Records returned"

________________________________________________________
Zameer Abdulla
Help to find Missing people
There’s a world of difference between editorials and advertorials

 

[0243906]

Sorry, im very stupid.
What do i replace 'anyfiledname' with. The query name, report name?

 

[Crowley16]

how about "any field name" in the query you are bounding to this report?

although personally I would use "non duplicated data within field's, name"...

--------------------
Procrastinate Now!

 

[CosmoKramer]

Or

=Count(*)

will work also....

Si hoc legere scis, nimis eruditionis habes