I have to tables in Access one is Boys and the other Girls.
I would like to get the total number from each table.
Select count(*) as Total_Girls from Girls;
Select count(*) as Total_Boys from Boys;
I would like the results to be in the same table.
Is there a way to do this in Access?