how to compare before and after

[dbertanjoli]

Please help with query/report. I have the following problem.

One student evaluates course before and after. There is several questions related to this evaluation (all are same before and after) and for one question there is 5 possible answer (stored in option group)

I would like to build a report or a query where I can compare data from each student (before and after) for all questions. Is this possible to do in access.

So, StudentA: questionOn: answer: one columen: before, second column: after…. Next question.

 

[Bodisathva]

As I see it, you have two choices:

1. Create a new column which designates the Before/After status of the entry
2. If you are using an auto number sequence as a primary key, there will be two entries per student, the lesser number will be the before eval, the higher number will be the after.