tracking iterations of different training classes

  • Thread starter Thread starter Roger Ball
  • Start date Start date
R

Roger Ball

my database tracks attendance at events with different number of
iterations. Event A may have only one iteration where Event B has 3.

tbl_Students
- StudentID
- L_Name
etc

tbl_Events
- EventID
- Event
- Iterations

If Event A has 1 iteration and Event B has 3 iterations I would like a
query to show:

A1 B1 B2 B3
Joe 1 1 0 1
Jill 0 1 1 1

where Joe attended (1) all events except B2 (0)

A pivot table where I could expand each event would be a super bonus.

Thanks for the help!
 
my database tracks attendance at events with different number of
iterations.  Event A may have only one iteration where Event B has 3.

tbl_Students
 - StudentID
 - L_Name
etc

tbl_Events
 - EventID
 - Event
 - Iterations

If Event A has 1 iteration and Event B has 3 iterations I would like a
query to show:

           A1          B1       B2       B3
Joe       1            1         0          1
Jill        0             1        1          1

where Joe attended (1) all events except B2 (0)

A pivot table where I could expand each event would be a super bonus.

Thanks for the help!
Click to expand...

Forgot the attendance table...

tbl_Attendance
- AttendanceID
- StudentID
- EventID
- Iteration
- StatusID (1 if attended, 0 if missed or still not taken)
 
Thanks, it worked.

I appreciate your contribution to the group over the many years. I've
learned a lot.
 
Back
Top