Church attendance tracking

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with a unique record for each member of our church. Right
now, we use a completely separate Excel sheet with a column for each Sunday
to track attendance. I would like to use access (so that the members list
updates automatically when we gain/lose someone). What's the best way to
track weekly attendance for a group of around 600 people?
 
Create a table (call it tblAttendance). It should have two fields:
PersonID
AttendDate

Each person is entered into one record for each date that they attend.
 
Back
Top