Joining queries and table issues

[Vasago]

I have a couple different tables(time work and Scheduled time) that are coming together to give employees actual worked times and their scheduled times to work. The first queries uses (date formatted to the number of weeks, hours worked, and the employee) which come from time work table. The second query (date formatted to the number of weeks, hour scheduled to work, and the employee). I have created a new table with the date formatted into weeks as a primary key to link the [date] fields. When i create a query to combine the scheduled work hours and the actual work hours, the query is only putting out the date field they both have in common.

My goal is to have all the weeks listed on the primary keep table and the other two queries filling in where their is data.

I'm sure I made this more confusing then needed.

Thanks for your help,
Vasago

[Seth Schrock]

In the query design view, double click on the line linking the two tables and then select the option that applies to your needs.