Search Access fields

[Allan]

I am a new user of Microsoft Access. I have setup a membership database
providing fields for names, address, etc. My organisation governs 12 clubs
so within the database I have a field for each of the 12 clubs.

A member can belong to as many clubs as he/she wishes eg club 6, club 4,
club2.

If I want to print mailing labels for all members in club 2 how do I select
only those members who belong to club 2 over the 12 fields?

 

[KARL DEWEY]

You should have at least three tables.
Member - fields for names, address, etc and a primary key (autonumber)
Club - title, dues, meetings, etc and a primary key (autonumber)
Club_Member - field for MemberID (foreign key matching Member primary key),
ClubID (foreign key matching Club primary key), Active, Paid_Up, and Paid_Date

Set a one-to-many relation from Member and Club to the Club_Member table.
Use a form/subform for data entry and display.

 

[John Vinson]

I am a new user of Microsoft Access. I have setup a membership database
providing fields for names, address, etc. My organisation governs 12 clubs
so within the database I have a field for each of the 12 clubs.

A member can belong to as many clubs as he/she wishes eg club 6, club 4,
club2.

If I want to print mailing labels for all members in club 2 how do I select
only those members who belong to club 2 over the 12 fields?

YOu're "committing spreadsheet upon a database" - a venial sin
punishible by being required to read about database normalization. <g>

Your table structure IS WRONG. Fields are expensive; records are
cheap! What will you do if two more clubs join the organization?
Redesign your table, all your forms, all your reports, all your
queries???

Consider instead a three-table structure:

Clubs
ClubID
ClubName
<information about the club as an entity>

Members
MemberID
LastName
FirstName
Address1
Address2
City
StateOrProvince
PostCode
<other personal data>

Membership
ClubID
MemberID
<any information about this member's membership in this club, e.g.
date joined, role, etc.>


John W. Vinson[MVP]