Cross-Tab or Count Records Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a bunch of queries that quickly tell me how many records in a
TBL. What I want to create is a summary report such as:

Query1 = X Records
Query2= X Records
Query3 = X Records

Would be just as simple to do:

TBL1= X Records
TBL2= X Records
TBL3 = X Records

But I can't seem to get it to work. Could you assist, or point me to a
webpage with a great tutorial?

Thanks,
Hank
 
Using the Northwind.mdb, try something like:

SELECT "Categories" AS TableName, Count(*) AS Records
FROM Categories
UNION ALL
SELECT "Customers", Count(*)
FROM Customers
UNION ALL
SELECT "Employees", Count(*)
FROM Employees;
 
Back
Top