Report data in a 2D table with checks

[aprentice]

I've a database for a private school.
Datas for the schedule are entered like this.

Student1 Lesson1 ClassA
Student1 Lesson2 ClassA
Student1 Lesson6 ClassA

Student2 Lesson2 ClassA
Student2 Lesson4 ClassA

and so on..

I want to view these data in a report with the following way:

.............Lesson1 Lesson2 L3 L4 L5 L6
Student1.....x...........x..................x
Student2..................x..........x

where x could be a true/false object
I've tried evth but I didn't find a solution.
Is it possible? Please help. I don't want to re-design the entire DB.

Ignore .... added for practical reasons

 

[Rich]

Use a crosstab query

 

[aprentice]

Use a crosstab query

thnx a lot
but my problem is how to assign the "x"
on each occurence of the desired info

 

[John Stanton]

2 dimensional data presentation

Hi - did you solve this one?

I have a similar problem except that I have a value that I want to show in the intersection (not a true/false). The value is stored on the intersection table.

John S.

 

[Bhaughbb]

I'd use an IIF statement in the value field of the crosstab that checks for the result to be true or at least not null and instead of the result include "x".

rough example

IIF([test_column] is not null,"x",)