Limit Number of Records Per Page - Access Report
Posted on 2006-04-23
I have a list of tutors, each tutor has taught a number of hours. Some teachers have 10 hours and some others have more than 50. The Official form has a place for only 15 hours, "Date, Sign, remarks".
I designed (imitated) the form in Access, it looks fine.
Now how can I limit each form to 15 records or less. If Dr. X has 10 hours, they can fit in one form, if Dr. M has 52 hours, I want the hours to be printed on 4 forms. Also when the Teacher's name changes a new form should begin.
Thanks a lot