Generating access reports of student data on different pages

[Jason1983]

Hi ,

This is Jason....I am very thankful to this community for helping me couple of times earlier with my issues....

Iam trying to create a Report which is attached to a Form ....On that form i have a combo box which will allow me to select "One particular student roll number" or i have an option to select "ALL" at the end of every month to get their marks from the database....

So my problem is when i select "ALL" option the report is generated but all the information multiple students is coming continuously on one single page....

But i want that to be splitted with each student having their information on a seperate page ....so that when i print each student gets his own copy seperately.....

iam using Access 2003 ....i could not find any option when i created the report....
Please help...
waiting for a reply...
Thanks
Jason...

[Rabbit]

Put a page break in the group footer of Student ID.

[Jason1983]

Put a page break in the group footer of Student ID.

Hello sir,

Thanks for the reply...But in the Footer i can only see these options.....

Name
Force New Page
New Row or Col
Keep Together
Visible
Can Grow
Can Shrink
Height
Back Color
Special Effect
Tag
On Format
On Print
On Retreat

So which one do i change...The option you suggested was not there....Please Suggest.....
Waiting for a reply...
Thanks
Jason.

[Rabbit]

It's not a setting, you just create a page break. It's a control.

[Jason1983]

It's not a setting, you just create a page break. It's a control.

Thank you very much sir.....I found it and that solved my problem......
Jason....

[Jason1983]

Make The Report Heading To Appear On Each Page

It's not a setting, you just create a page break. It's a control.

Hello Sir,

I just have one more question....I have made a heading for the report and put it in a LABEL and I have put the Page Break as you have suggested and When i go to preview the report as there is a page break the Name only is appearing on the first page and not on the rest....These are individual student assesments ...so that was the reason for seperating them and that works with page break option you suggested.....B ut how to make the Name,Date,Time inserted in the header appear on each page.....

waiting for ur reply...
Thanks
Jason

[jaxjagfan]

Put the labels and text boxes you want appearing on each page in the page header vice the report header. The labels should be correctly displayed then. If not showing go to the View option from the menu.

Another way to put each student on seperate page. If your report has groupings in it and you have a Student Footer. In the Format - Force New Page property - Select "After Section"