Presumably your table has a primary key field, named (say) MemberID?
If so, open the report in design view.
Open the Sorting And Grouping Dialog (View menu.)
Choose the MemberID field,and in the lower pane answer Yes for Group Header
and Group Footer. Access adds 2 new sections to the report. Initially they
are about 1/4 inch tall, but you can make them up to 22" tall each.
You now have 3 sections (MemberID Header, Detail, and MemberID Footer.) Put
the first 2 pages in the MemberID header, the next 2 in the Detail, and if
you need more pages, add them to the footer. These sections are printed for
every record, since they are based on the primary key.
That should get you out of trouble for now. But you might like to consider
whether some of these fields should be in related tables. Particularly, any
repeating fields should be *records* in a related table instead of *fields*
in this table--fields like Payment1, Payment2, ... or Attendance1,
Attendance2, ... or Parent1Address, Parent2Address, ...
The Table Analyzer (Tools menu), might be able to help make suggestions too.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
message
news
[email protected]...
