Access for recordig visits on a Daily Basis

[phineas629]

Hi all,

I am stuck on what to do. No amount of reading or tutorials is helping as I'm still very new to Access.

Here is the situation:

1. I have volunteers visit clients on a near-daily basis.
2. Each client is only allow a set total number of visits within a time frame.
i.e. volunteer 1 visits client A for 300 visits for the year. volunteer 2 visits client B for 280 visits for the year.
3. Total number of visits for each client must be met.

I'd love some directions on how to approach this problem.
I've made multiple tables: volunteers, clients. It just seems too crazy to make individual tables for each client as I have 50 total. There's got to be an easier way.

Thanks in advance

[pbaldy]

I see a third table, with fields for client, volunteer and date (and whatever other fields might be appropriate. In your example above volunteer 1 would have 300 records in that table and volunteer 2 would have 280. It would be very simply to get counts by client, volunteer, etc.

[ketbdnetbp]

If you don't already have one, consider adding a VisitDetail table. Something like:

tblVisitDetails
VisitDetailID (PK)
VolunteerID (FK)
ClientID (FK)
visitDate
etc.

That way, you'll be able to use queries to get your needed data.

[phineas629]

Thanks,

I sure didn't know the trouble I was getting myself into when a friend suggested using Access. I'll report back on how successful I am with the suggestions given.

[pbaldy]

No problem, and welcome to the site!