I am attempting to create a report that will give daily concert production schedules. I currently have a single form for each performance we put on. On the form there are fields for load-in day, load-in time, load-out day, load-out time, rehearsal day, rehearsal time, performance day and performance time.
On the report, I would like each page to show a week with one column for each day of the week (no problem). However, I would like each day divided into morning, afternoon and evening with each activity appearing on the correct portion of the page. Therefore if the only thing that happens on Monday is a Tony Bennett performance at 8PM, the text "8PM Tony Bennett Concert" should appear at the bottom (or near the bottom) of Monday's column. It is likely that each portion of the day will actually have several activities to be listed (8PM Concert, next line 10:30PM Load-out). It seems to me this should be possible, but I have not yet had a revelation. There is some flexibility in format and I'm comfortable with SQL or VBA. Any thoughts?
On the report, I would like each page to show a week with one column for each day of the week (no problem). However, I would like each day divided into morning, afternoon and evening with each activity appearing on the correct portion of the page. Therefore if the only thing that happens on Monday is a Tony Bennett performance at 8PM, the text "8PM Tony Bennett Concert" should appear at the bottom (or near the bottom) of Monday's column. It is likely that each portion of the day will actually have several activities to be listed (8PM Concert, next line 10:30PM Load-out). It seems to me this should be possible, but I have not yet had a revelation. There is some flexibility in format and I'm comfortable with SQL or VBA. Any thoughts?