Simple Report Help Needed

[twitchie]

Greetings. I am having trouble with a report that I think is a simple one to solve for someone who has spent a little more time with Access than I have. Anyhow, I have 7 separate tables which are populated by data from 7 different forms. Each one corresponds to a day of the week. I then have this report which I want to draw the results from each day into. The problem is that I have to draw data from different tables into one report - which Access doesn't like. I know I need to set up a quesry and link the tables, but I am confused as to exactly how the query should look. Do I just like every field in every table to the corresponding field in the next day's table? Do I put any expressions in the Criteria boxes? I am really having trouble conceptualizing this. Your help is greatly appreciated.

James

 

[Rich]

I'd say you have a structure problem with your design, you don't need 7 tables to enter data for each day, just one with a date field will do, search here for more help on Normalising your db.