Record count for more than 1 table

  • Thread starter Thread starter Danielle
  • Start date Start date
D

Danielle

is there a way to create one query that will give you the
record count of several different tables? Don't need any
joins...just how many records in each table.

Or, is there a better way to get that?
Thanks!
 
Danielle

Is there a reason why you have several tables that hold things of interest
that you could count? I'm asking because there's a chance you don't need
several tables ... What kinds of data are these tables holding?

More info, please...

Jeff Boyce
<Access MVP>
 
Jeff,
There are 8 tables of data that need to be kept separate
for 8 different mailing versions for eventual mail merge.
I need to count to determine which, if any, on a daily
basis, contain enough records for a Presort.
 
Take a look at a UNION Query.

SELECT "MailListA" as ListID, Count(*) as CountListA
FROM MailListA
UNION All
SELECT "MailListB" , Count(*)
FROM MailListB
UNION ALL
....
 
Back
Top