Total record sum

[gmaster]

Hi, i've got a DB with a dozen tables and i was trying to find a way to put number of records contained in the DB, into the intro form. I mean, i wanted it to show the sum of the number of records in each table....i was trying with some query, but maybe is more functional VBA?

[ranman256]

make a table to record the totals, say tDBTotals

now make a query to append the totals
insert into tDbTotals ([Table], [Count]) values ("empoyees", Dcount("*","tEmps")
insert into tDbTotals ([Table], [Count]) values ("Accts", Dcount("*","tAccts")
etc..


build a macro that has these append queries..
the macro empties tDbTotals
then all the append queries.
done.

[gmaster]

Thanks! I adjusted a little and works just fine