Record Count in a Query

[Mike S]

I need to to get a record count on every query I run and
then display that in my report. I tried DCount and
Totals>Count and I dont know if I m using them wrong but I
can get it. I think I need specific intructions, Please
help.

 

[[MVP] S. Clark]

To display it on the report, you do not need to calculate it in the query.

In the Report Footer, add a text box that holds the Count of some unique id.

i.e. =Count([OrderID])


--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-