A challenging query on reports(atleast for me). Pls help

[satswid]

Hi,
I am very new to this forum as well as MS-Access. I am stuck at the very beginning.. Plz help

This is my requirement

I have a student table


with these columns
Roll No, Name, Class, Subject, Percentage

I will create a form where user selects the class and then click "Generate Report".
I want a class-wise report in this format.

Header---------------
Class: xyz
School: abc

Detail------------------------------------
Roll No | Name | Subject | Marks
001 Student1 Maths 79
001 Student1 Science 99
001 Student1 History 99
002 Student2 Maths 87
002 Student2 History 88
002
003
003
003
004
etc
***
***
***

*It will go for multiple pages with same header

**
**
**
**


________________________________________
Totals
----------------------------------------




Pls help me by providing a sample of this situation. I am really stuck somewhere.

[June7]

Put label and field for Class in Page Header. Also put the labels for the detail fields in the Page Header.

If you want to restrict the report to one class, then need to open report filtered to the one class selected. You can use a query as report's RecordSource and set a criteria under the Class field that refers to the control (combobox?) on form as parameter. The syntax would be: Forms!formname!controlname.

If you want the report to show all classes then use report Grouping & Sorting functionality. I presume is only one school because there is no field in table for school. Create a Group Header in the report on the Class field. Criteria syntax would be: Like Forms!formname!controlname & "*". If combobox is empty, report will open with all classes.

[satswid]

Put label and field for Class in Page Header. Also put the labels for the detail fields in the Page Header.

If you want to restrict the report to one class, then need to open report filtered to the one class selected. You can use a query as report's RecordSource and set a criteria under the Class field that refers to the control (combobox?) on form as parameter. The syntax would be: Forms!formname!controlname.

If you want the report to show all classes then use report Grouping & Sorting functionality. I presume is only one school because there is no field in table for school. Create a Group Header in the report on the Class field. Criteria syntax would be: Like Forms!formname!controlname & "*". If combobox is empty, report will open with all classes.

Thanks a lot