Counting total records in select query

[geronimo_me]

Hi,

I have a query that has the following fields:

Business:
ID Number:
LastName:
EmpNo:
Hours1:
Hours2:
In the Hours1 criteria I have <>[ImportedSalFile]![HOURS]

So basically this query shows me all records where Hours1 and Hours2
that DO NOT match .

Is it possible to add another column to the query to show the amount of
records this query produces each time its ran. I export this query into
excel and wanted to be able to export the number of records for the
query, each time the query is run.

Many Thanks

Flick. x

[David Seeto via AccessMonster.com]

>Is it possible to add another column to the query to show the amount of

records this query produces each time its ran

Just trying to understand what you're trying to do here - you want all of
the records, and then a separate line that tells you the count of the total
records? If so, I'm afraid that's not the sort of thing a query can output
in one go - you'd need to put together a report with the output of your
existing query, plus the output of another query that counts the number of
records in your existing query. What is your query actually trying to show?
I can't tell from the details you've posted what the ID Number applies to,
otherwise I could be post some code for you...

--
Message posted via http://www.accessmonster.com