Counting data from multiple tables

[dark11984]

I have 3 tables, Table A, Table B & Table C. I need to count how many records exist in each table and append those 3 counts into 1 table in 3 different fields with the date. Column1 = Today's Date, Column 2 = Table A, Column 3 = Table B, Column 4 = Table C.

Any help?

 

[khawar]

You can use an append query to populate table
It could also be done in vba

 

[Pat Hartman]

create three queries to summarize the three tables by date. Create a fourth query to join the other three on date. Once that works, you can change the fourth query to an append query if you must store the value. Generally it is wrong to store values that can be calculated so I don't recommend it.