Attendance Table

[Yukonbanzai]

Not sure of the most effecient way to keep track of a groups attendance.
The group meets once a week. There are between 20 and 40 people. Need to be able to mark every person as either "present", "excused", "sick", or "awol".
All personal information is currently in a table named "Data".

If anyone can point me at threads, links or what-have-you that will give me options would be greatly appreciated.

 

[BNPMike]

It's best if you post questions like "is the acceptable creep on the port number 6 tyre 2mm", rather than "how do you fly airliners".

I suggest you think about splitting the data model into people and meetings (ie dates). Then define what information you are going to want out of your system.

To update your database I can imagine you would want to flag those people still in the group, and then create an append query which creates a new record for each person for a given date. You can then display that new set on a form with an option group.

That's one fairly simple approach.

 

[Yukonbanzai]

I've got an existing table with the people in it and I've created a table with meeting dates that are given ID numbers. I just can't seem to grasp how to put them together to keep track of attendance.

tblData
LastName
FirstName

tblDate
MeetDate
DateID

 

[BNPMike]

Add a key for covenience to tblData. Add a flag so you don't keep getting people who you know have left the group.

tblDate currently brings nothing to the party so we'll ignore it.

Add an intersection table tblAtt that connects people to meetings. Create a field AttendanceCode that is say 1=present 2= sick etc.

Load tblAtt by selecting all MemberId where ActiveFlg = Active, Set Meetdate = Date(), for example. Then write a query off tblAtt for the date in question and fill in the attendance codes.

tblData
MemberID
LastName
FirstName
ActiveFlg

tblDate
MeetDate
DateID

tblAtt
MeetDate
MemberID
AttendanceCode