Creating a Report from Multiple Tables

[River Rouge Library]

I've set up a database to record answers to a survey that we are doing. I
created a different table for each question to record the various answers.

Basically, I need to run a report with two of my tables where it sorts the
data from one table based on the data that was entered in the other table.

More specifically: In table one, I asked people to select a day of the week.
In table two, I asked them to select: morning, afternoon, or evening. In the
report I need to show how all the people who answered Monday in table one
responded to the question for table two. That way we'd know whether people
overwhelming wanted Monday afternoon or Sunday evening, etc.

I hope this makes sense. Any help you can give would be appreciated.

 

[John Spencer]

OUCH!!!!!

You should have one table that stores all the questions and responses to
the question.

Your current structure will be VERY difficult to work with.

To even attempt to help you will require more information on your table
structure.

For instance, is there a column in both table one and table two that can
be used to tie the record in table one to a specific record in table two?

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================