Getting information from several surveys in Access

[forest8]

Hi there

I have created three surveys which contains information from students. The
students complete the surveys at intervals of 3 months so within 1 year a
student can have, at most, completed 4 surveys. The pre-survey which is
conducted at the start of the year and a survey at the end of the first term.
The post survey that is conducted at the end of the second and third terms
has elements of the pre-survey and the survey that is conducted at the end of
the 1st term.

For instance, on questions on how they rate their teachers on a range of
topics such as knowledge, ease of explaining new terms, addressing students
needs, has teaching improved since the previous term, etc.

I have 3 tables because there are three different surveys but there are
similar questions in all the surveys but they're not all the same. The
pre-survey is the shortest. The post survey the longest.


What I want to do is see all the results for the same questions on a single
report. For instance, for each student, I want to see if their ratings have
changed over time (at the beginning to the end).

Thank you in advance.

 

[KARL DEWEY]

You talked a lot about your methods but nothing of the table and field names
or datatype.
There is two ways to view data from multiple tables - vertical or horizontal.

For vertical use a union query.

For horizontal use a common field and join the tables. You may need to first
use a union query to create a complete list of data that is your common field
and then left join that to the other tables.