SUBSIM Radio Room Forums - View Single Post

sonar732 · 10-23-07, 07:36 PM

Hey everyone!

Ok. I've got a group of people located at mutliple offices who are members
of different committees. I can't figure out a query to create which will
show the office they are in, the first and last name of the person, and the
committees that they are part of. There are multiple offices, 7 having
membership right now, 60 members stretched between them, and there are 4
committees. Another wrench is that they can be in more than one committee.

This is the basic setup of the tblMembership. As you go down, it's another
field. I've attempted to create multiple option groups so I can have each committee that they are a part of within my tblMembership, but it's not panning out.

ID
Member ID
First Name
Last Name
Location-related to tblLocations
Phone Number
Email Address
Veteran

I have a seperate tblCommittee for the 4 committees already setup.

ID
Committee

In the trial queries that I've attempted, it shows each member belongs to
each committee even though that's not the case.

10-23-07, 07:36 PM	#1
sonar732 The Old Man Join Date: Jul 2003 Location: Central MO Posts: 1,562 Downloads: 6 Uploads: 0	MS Access Query/Report Question Hey everyone! Ok. I've got a group of people located at mutliple offices who are members of different committees. I can't figure out a query to create which will show the office they are in, the first and last name of the person, and the committees that they are part of. There are multiple offices, 7 having membership right now, 60 members stretched between them, and there are 4 committees. Another wrench is that they can be in more than one committee. This is the basic setup of the tblMembership. As you go down, it's another field. I've attempted to create multiple option groups so I can have each committee that they are a part of within my tblMembership, but it's not panning out. ID Member ID First Name Last Name Location-related to tblLocations Phone Number Email Address Veteran I have a seperate tblCommittee for the 4 committees already setup. ID Committee In the trial queries that I've attempted, it shows each member belongs to each committee even though that's not the case.