View Single Post
Old 09-01-2019, 11:16 AM   #21
Newly Registered User
Join Date: Jul 2019
Posts: 105
Thanks: 2
Thanked 0 Times in 0 Posts
Lkwdmntr is on a distinguished road
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.
Lkwdmntr is offline   Reply With Quote