combine 'same' data in 2 fields in report

[Guest]

I am designing a membership database which also records committees people
serve on. However, I have two separate "sets" of fields where I can put info
in for one person who serves on 2 committees (Committee-1 and Committee-2).

I am battling to understand how to set up a query which will group on the
name of the committees (I can do that), but will also give me the name of the
same person under both of the committee groupings. Often the positions they
hold are also different (Position-1 and Position-2).

 

[Duane Hookom]

You have a normalization issue. What happens if a person serves on more than
2 committees?
Your committee membership should be stored in a related/child table.

tblCommittees
============
CommitteeID
CommitteeName

tblCommitteeMembership
==============
CommitteeID
PersonID
StartDate
EndDate
MembershipStatus

You can then easily create a report of committee members as well as serve on
more than two committees.

 

[Guest]

Thanks Duane ... will give it a try. Still new to Access and on a steep
learning curve!!

Mags