Hi
Is there a way of counting the records in a number of tables and then inserting the table names and counts into a table. I have a table with the names of all the tables in it as this is populated when I import from excel.
The resulting table would be
Name Count
Table1 25
Table2 35
etc
I am using Access 2010
Thanks for your help
Rich
Is there a way of counting the records in a number of tables and then inserting the table names and counts into a table. I have a table with the names of all the tables in it as this is populated when I import from excel.
The resulting table would be
Name Count
Table1 25
Table2 35
etc
I am using Access 2010
Thanks for your help
Rich