Query/Report combination

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
How is this data loaded in to tables and fields? Table and field names
with datatype. Sample data would help also.
 
This is the basic setup of the tblMembership. As you go down, it's another
field.

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.
 
It seems to me that you are missing at least one table. You need a table
tblCommitteeMember that links tblMembership to tblCommittee.

tblCommitteeMember
-- MemberID
-- Committee

(If this is the tblCommitteeMember.Committee contains the name of the
committee then your query is)

SELECT TblMembership.*, tblCommitteeMember.Committee
FROM TblMembership INNER JOIN tblCommitteeMember
ON tblMembership.Id = tblCommitteeMember.MemberID

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Back
Top