One record per page?

[Paine]

Apologies if this is something ridiculously easy - I'm new (but learning fast!)

I'm putting together a student records system. The database is fine, working on three tables: 'students' , 'courses' and 'enrollments'. The forms, sub-forms and relationships all work beautifully; but I'm having trouble with reporting.

I want to generate a report for each student detailing the courses they have enrolled on. - a very simple A4 page which we can print and give to the students at the end of their learning so they can track the courses they have attended.

I thought it would work by putting data from 'students' in the Page Header of the report in design view, and data from 'enrollments' in the detail section. Apparently this is not how to do, it spurts out a lot of meaningless data (pages and pages of enrollments that are not related to the student's name at the top of the page).

Can anyone help me with this, or point me in the direction of some helpful tutorials that will sort me out?

What I'm after...


Report Header:
--------------
School logo


Page Header
------------
Student Name
Student ID
etc


Detail Header
-------------
Course Name
Date Started
Date Finished
Score


Detail
------
Data from Enrollment table


Page Footer
------------
page number


Report Footer
-------------
Printed on, by, etc...


Thanks in anticipation - I'm new to Access!

 

[wazz]

i'm not checking this, but i think you have to go to 'Sorting and Grouping' then make a selection under 'Keep Together' or something like that.

 

[gemma-the-husky]

yes

group on the student number, and force page break after each group - will certainly give you a page per record

 

[Paine]

Thank you both for your help. It has taken a bit of playing about, but I've managed to get a very simple student report together and working now thanks!

I need to practice designing my reports and how to use Page Breaks - I haven't quite mastered it yet and it's spitting out a blank page after every record. I guess I probably need to pop the page break in the page footer instead?

Thank you for your help - much appreciated!



Steve

 

[gemma-the-husky]

if you are specifiying a page break after each change of group - then adding another expcilitly within the footer will be giving you an extra page break.