Populating Dates

[sr71aa]

I have two tables. One is a simple two column table with Short Date and the corresponding Day of Week. My second table is an employee schedule based on Day of week. I bring the two together by the "Day" variable to generate a schedule for a specific time period, but I also want it to return the days where there is no data.

For example, I have a schedule listing like this:

J SMITH MON 8:00 16:00
J SMITH TUE 8:00 16:00
J SMITH WED 8:00 16:00
J SMITH THU 8:00 16:00
J SMITH FRI 8:00 16:00

My result is this:

J SMITH 9/18 8:00 16:00
J SMITH 9/19 8:00 16:00
J SMITH 9/20 8:00 16:00
J SMITH 9/21 8:00 16:00
J SMITH 9/22 8:00 16:00

I want to see the following:

J SMITH 9/18 8:00 16:00
J SMITH 9/19 8:00 16:00
J SMITH 9/20 8:00 16:00
J SMITH 9/21 8:00 16:00
J SMITH 9/22 8:00 16:00
J SMITH 9/23
J SMITH 9/23

Is there any way that i can see this without manually entering the "Days Off" in the main table?

 

[ejstefl]

Use a Left Join. Right Click on the link between your two tables, click on join properties, and choose Include All records from 'Date' table and only those records from 'Employee' table where the joined fields are equal.

 

[sr71aa]

Thanks. I tried that but still no go. It excludes the days that don't appear in the main table. Any other suggestions?