How to display several queries seperately in one report?

[lanye]

Hi All,

I'm a beginner.

I have 3 queries based on a table "Student".
They contain information about students in class 1, 2, and 3 respectively.
And I want to display information in these three queries in one report with labels between.

So the report looks like this:

Class 1
Student name Age
.........

Class 2
Student name Age
.........

Class 3
Student name Age
.........

Is there anybody can tell me how I can do this in Access?

Thanks a lot.

Gratefully,
lanye

 

[trucktime]

Report

You really don't need 3 queries.
Just one will do and use the report sorting and grouping to achieve the result you want.

 

[lanye]

Thanks for your reminding.

I did so and it works.

Still I have another question:
For the labels in between different classes, I want to add the teacher's name of that class. The teacher's information is stored in another table called "Teacher". And it contains the teacher's name as well as a field "Class". So how can I put the teachers' name into corresponding labels?

Thank you.

Gratefully,
lanye