Please help...

[msstephens]

I'm fairly new to access and I need to create what I believe to be a very complex query and then transfer this information into a report to print. I have multiple tables which include sessions individuals have selected to attend during an event. All tables have the same headers but they are different days (ex. Monday table, Tuesday table). Each table include the time the session will be held (ex. Session 1 9-10am, session 2 10:15-11:15am). I'm trying to run a query that will provide me each individual's schedule for each day and each time slot (in date and time order if possible). Once I'm able to obtain this information I need to be able to put this information in a report format to print for each attendee's review.

I've thought this through several different ways and nothing that I've come up with is working. Can anyone tell me if this is even something I can do in Access 2007? Also, let me know if more detail information is needed.

I apologize for the lengthy post.

Thank you,