Count records from multiple tables

[jazzin]

Hi all,


I have 14 different tables and I want to count the number of records in each table and display the results. Ex
Select Count(Field_Name) As Column_Heading
From Table;

But I want to do this for all 14 tables. I'm close but still haven't figured it out.
Can you help?

[jazzin]

[QUOTE=jazzin;182598]Hi all,
I have 14 different tables and I want to count the number of records in each table and display the results. Ex

SELECT Count([3_0_addr].ADDRESS) AS Expr1
FROM 3_0_addr;

This works for 1 table but I want to do this for 14 different tables. Each table contains a different number of records
Can you help?