I'm designing an enrollment database for a summer camp program. It runs all summer and has up to seven different classes each week.
I have a form that allows for each child's information to be entered, and then a week by week pick of which class they will be in which brings the information to my master table of enrollements.
What I need to do is create a report which will bring up all of the classes each week and what students are enrolled. Because there are 70-something classes, I don't want individual reports, but just once each week, which has all of the classes. However, I can't figure out how to get the layout of my report so that each class is on a different page.
What it looks like is
Class 1 Name 1
Name 2
Name 3
Name 4
Name 5
Class 2 Name 1
Name 2
Class 3 Name 1
Name 2
Name 3
Name 4
and so on. Does anyone have any ideas of the best way to solve this?
I have a form that allows for each child's information to be entered, and then a week by week pick of which class they will be in which brings the information to my master table of enrollements.
What I need to do is create a report which will bring up all of the classes each week and what students are enrolled. Because there are 70-something classes, I don't want individual reports, but just once each week, which has all of the classes. However, I can't figure out how to get the layout of my report so that each class is on a different page.
What it looks like is
Class 1 Name 1
Name 2
Name 3
Name 4
Name 5
Class 2 Name 1
Name 2
Class 3 Name 1
Name 2
Name 3
Name 4
and so on. Does anyone have any ideas of the best way to solve this?
