bringing two tables together

  • Thread starter Thread starter Ashley
  • Start date Start date
A

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
 
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
Click to expand...

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.
 
Back
Top