|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 14th, 2004, 05:37 PM
|
|||
|
|||
Church attendance tracking
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? 
|
|
#2
December 14th, 2004, 05:57 PM
|
|||
|
|||
|
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. -- Ken Snell MS ACCESS MVP "Josh Kingcade" wrote in message ... 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?
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| tracking changes | Mary | General Discussion | 1 | October 7th, 2004 04:20 PM |
| Login Tracking Table | Robin Lawrie | Database Design | 2 | September 29th, 2004 09:05 PM |
| Tracking | Sam A | General Discussion | 1 | September 15th, 2004 03:13 PM |
| How do I set up an attendance tracking calendar in Access? | Dan Corbett | General Discussion | 1 | September 4th, 2004 02:51 AM |
| XP; Outlook 2002 and Voter Tracking Tab issue | Perplexed | General Discussion | 2 | July 21st, 2004 01:51 PM |
Linear Mode
