how count records found by a query?

[susanmre]

Forgive if this is a dumb question... I am very new to Access. I have done many searches here but can not find the answer I need. Maybe I do not know exactly what to search for?

I have been given a huge database Table to work on.
I have several simple queries on it which work fine.

Boss would like to see, when the query runs, not only the query results but also, as part of the query, a count of how many results (records) the queries finds. I have not been able to figure out how to do this.

Any suggestions would be greatly appreciated.

SQL code for one of my queries can be supplied if needed.

Susan

 

[Andrew Fergus]

Hi Susan and welcome to Mr Excel.

You might want to try the dcount function. You can use it to count records within a query. Following is a link to a Microsoft article explaining how to use dcount here.

If this is not what you are after (or if it gets too hard), then you could present the information from the query in a report where it would be easier to count the records. There is an article explaining this here

Hope this helps. Andrew.

 

[Norie]

You could just look at the statusbar type thingy at the bottom of the query which
tells you which record you are currently on and also how many records there are.