Question: Counting records in multiple tables in one querry
I'm creating an Access 07' database for tracking quality audits my department. There are a total of 11 audits we do, each with it's own table of records within the database.
I want to create a query that will count the total number of records created for a given date. This date is stored in an Audit Date field that is in every table.
What's the easiest way to do this?