Access Query (2003)

Topic

New Reply

Is it possible to display the record count in a query?

Reply | Quote

Replies

Why do you want to do this?

Is the query run from VBA code?

You could make a function to do this?

Reply | Quote

I have queries that specify different criteria for a table. Each query gives me a different result – I need the record number of the queries to create a chart. Hopefully this makes sense. Thank you.

Reply | Quote

You can create query that counts records, but if you you will no longer see all the records.
Include just one field (they key) and click the totals button on the toolbar.
This will add another row to the query grid. Put count on this line.
When you view the results, you will just see the count.

Reply | Quote

Use: Dcount(“*”, “..your query name here…”)

Reply | Quote