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.
Class: xyz
School: abc

Student 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.

 

[vbaInet]

This site explains how you can group data in a report:

http://office.microsoft.com/en-us/access-help/create-a-grouped-or-summary-report-HA010006894.aspx