I want to display a record count in a query

T

travelin

I would like to see a field showing the number of records returned in my
query, how can I do that?
 
E

Ed Robichaud

Create a "Totals" query and "count" the number of records "grouped by" some
other field.
-Ed
 
J

John Spencer

Can you post the SQL text of your current query? And can you explain why you
need to do this? And where - in a form, in a report, ...?

You may be able to use DCOUNT to do what you want in a query.
On a form, you might use RecordSetClone.RecordCount
In a report, you might use =Count(*) as a control's source in the report header
or footer.
 
Top