I am having difficulty trying to create a query/form for calculating training ho

[David]

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
attendance.

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!
David

 

[Steve Schapel]

David,

Obviously I don't know enough about your project to be definitive.
But on the basis of what you have told us, it looks like you would
need at least four tables, something like...

Table: Personnel
MarineID
FirstName
LastName
etc

Table: Subjects
SubjectID
ClassSubject
Category
etc

Table: ClassSessions
SessionID
SessionDate
SessionTime
Venue
etc

Table: Attendance
AttendanceID
SessionID
MarineID

Things like numbers in attendance, man hours, etc, would not be
entered data, they would be derived by calculations in queries from
the entered attendance data. Hope that might help give you some
direction.

- Steve Schapel, Microsoft Access MVP