Church attendance tracking

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Josh Kingcade - 14 Dec 2004 17:37 GMT

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?

Reply to this Message

Ken Snell [MVP] - 14 Dec 2004 17:57 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

> 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?

Reply to this Message