I am a US Marine Crash Fire Rescue Specialist and am
currently assigned as a Training NCO. One of my primary
duties is to keep track of all of the training that we
do. I have 60 Marines, divided into 3 sections, and need
to track the following information on each of them:
1. Class Date
2. Class Hours
3. Class Subject
4. Class Category
5. Number in attendance
6. Total Man Hours
7. And whether or not the individual attended.
I would like to be able to fill-in the information in a
header and then click a checkbox for those who were in
My main problem is that I have not figured out how to
create a separate record of each class including all of
the students and who did and did not attend. The
queries/forms that I make never recognize the checkbox as
being new when I make a new class record. They stay
checked or unchecked from the previous class record.
Any help you could give would be GREATLY appreciated!!!
Thank you for your assistance!