bringing two tables together

[Ashley]

I have Date and LN_No in one table and Date and NoPeople
in another table.
I want to bring these two tables together so they are
group by date, Count of LN_No, and Sum of NoPeople.
Please help if you know how to do this!
Thanks

 

[John Vinson]

I have Date and LN_No in one table and Date and NoPeople
in another table.
I want to bring these two tables together so they are
group by date, Count of LN_No, and Sum of NoPeople.
Please help if you know how to do this!
Thanks

Create a new Query; add the two tables to it. Join them by [Date] (by
the way, this is a risky choice of fieldname, since it's a reserved
word for the Date() function).

Change the query to a Totals query; group by [Date] - either one - and
select Count and Sum for the other fields.

Note that if there are records which exist in one table but have no
corresponding date in the other, you'll not see these in the query at
all. If you need them a more complicated query will be required.