By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,493 Members | 1,233 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,493 IT Pros & Developers. It's quick & easy.

Generating access reports of student data on different pages

P: 27
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...
Jan 3 '08 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,315
Put a page break in the group footer of Student ID.
Jan 3 '08 #2

P: 27
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.
Jan 4 '08 #3

Rabbit
Expert Mod 10K+
P: 12,315
It's not a setting, you just create a page break. It's a control.
Jan 4 '08 #4

P: 27
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....
Jan 4 '08 #5

P: 27
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.....But how to make the Name,Date,Time inserted in the header appear on each page.....

waiting for ur reply...
Thanks
Jason
Jan 4 '08 #6

jaxjagfan
Expert 100+
P: 254
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"
Jan 4 '08 #7

Post your reply

Sign in to post your reply or Sign up for a free account.