Re: Creating a Report from Two Tables
All the records aren't there. If you notice in the Weekly_Challenges table there are "T"'s and "X"'s or nothing. That is how I need the report to look, but the actual time that is in the Weekly_StartTime_Challenges Tabel. For instance:
Action Mon Tue Wed Thur Fri Sat Sun
HouseKeeping Routine X 2:00PM X 2:00PM X 2:00PM
Exercise Routine 3:00PM X 3:00PM X 3:00PM 3:00PM
Don't concern or worry about the Main Header. I will plug all of that information in. I hope this gives you a better idea of what is needed. Imagine everything in columns, it's hard to replicate what is needed in this textbox. Sunday has no timed value or X value, so it is blank.