Get info: Number of records in tables

[Bradley C. Hammerstrom]

Access2000

Is there some way of creating a query or such that can display the number of
records currently contained in a list of tables?

Brad H.

 

[GVaught]

You will have to create initial queries for each table you want to count.
You only need to add one field to each query and turn on Totals. Set the
field you add to the query to count. Then make a new query and add each of
your count queries into a new overall query. When you run this query it will
run the other queries and you should get the updated count on each table.

For example: I created three queries; customers, employees and parts. Then I
created another query and added the customer query, the employee query and
then the parts query. When I run this query I get this result.

Customer Count Employee Count Part Count
3 4 6


Note: I changed the CountOfCustomer to Customer Count by opening properties
for the field and changing the Caption box to Customer Count. You could just
as easily name this Customer Table Employee Table etc. or whatever name you
want.

 

[Bradley C. Hammerstrom]

Works great!

thanks, G