2 Relationship Query

[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.

 

[KARL DEWEY]

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