Cross-Tab or Count Records Report

[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

 

[Duane Hookom]

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;

 

[Guest]

Perfect, Finally got back to this task, and it worked perfectly.

Hank