Info gathering

[agorman]

Hi,

I have been struggling with a project and cannot seem to get a solution. The following is a bit drawn out so I apologies, but if anyone can help - (or tell me if it is not possible) I would be grateful.

I have a club DB with 42 members, and have a table with members details etc.

They meet 12 times a year and I have a table with details of the meetings (each meeting is a separate record with date, venue etc)

I use forms to view the records.

What I would like to do is be able run a query/report to see who attended each meeting/or how many meetings an individual attended over the year. (I have not got to the query/report stage yet, as I cannot figure out how to set up the information).

(I need to know each year how many meetings an individual attends)

I thought of putting a list of the members and a tick box next to their name on each of the 12 meeting records, (which will update when members join/leave) then be able to run a query with the name of the member, and the dates (or number) of the meetings attended, but don'y know how.

At the moment all I can think of is a memo field, and just type in their names on a specific meeting record.

Any help would be gratefully received

Regards

Adrian

 

[neileg]

You have a many to many relationship between members and meetings. The way to model this in Access is with a junction table. You may want this table to hold more data, but at its simplest level it will hold the ID of the member and the ID of the meeting. Thus if a member attends every meeting in a year there will be twelve records in the junction table.

Do a search on many to many or junction table in these forums for more advice.

 

[CraigDolphin]

You may be interested in checking out Banana's protype db that may offer you some clues how to proceed. You can find it here:
http://www.access-programmers.co.uk/forums/showthread.php?t=131902