SUBSIM Radio Room Forums - 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.