I'm teaching a few classes at a summer camp and am building a database
on the kids taking the classes and the objectives in the class. I have
two questions though.
1. I have to periods of the same class and would like to join the two
tables together, I assume with a query, to make a report. The report
is seperated by troop number (ID number for where a kid is from) and
displays all the other information from the class. I would like it to
make one report rather than a seperate report for each of the two
classes. I tried making a query and joining two tables together by the
ID Number (The auto generated value) and it only puts the kids in the
first class in the query. How should it be done?
2. I have the report grouped by the troop number with a pagebreak
after everybody that is in the same troop number. How do I add the
title and footer to each page so it shows the same title on each page
and so forth?
Thanks,
Matt