2 Relationship Query

  • Thread starter Thread starter NFMer
  • Start date Start date
N

NFMer

Hello,

I have a table that contains User id, hours worked for that day and the
date. This table will contain info for multiple days of data. Then I have
another table that contains the user id, date and production numbers, also
containing multiple days worth of data.

I need to have a query that will combine into one new table the user id,
hours worked and production numbers. This query will ideally ask the user to
select a date range of data to pull. The relationship I’ve been trying to
work with is date and user id, but that does not work and does something
crazy.

Please Advise.
 
You need a Master table containing UserID of all to be left joined in the
query to the other two tables.
 
Back
Top