unique records problem

N

Nancy

I know how to use the unique records property in my query. The problem is
that there may be one field that is different and this causes a duplication
in my list. There are 2 tables in the query. I need to list all people who
are on committees in an organization. When one person is on more than one
committee, the committee field has a different value so the person appears
twice on the email query or on the mailing labels query. How can I get the
query to list the person only once?

Many thanks for your help.
 
B

Brian

As long as you are including the duplicate info in the query, you will get
two output entries for the person. Make another query just for your mailing
list. Leaves out the field that is duplicated. Once the query is done, go to
SQL view and change it from SELECT... to SELECT DISTINCT...

If you instead want labels for everyone on a particular committee, then put
the committee name or ID in the criteria for the box that shows the
committee, and it will include only those people on that committee
(presumably once each, unless someone is actually listed as being on the
committee twice).
 
N

Nancy

Thanks Brian. I'll try setting up a query on the query and changing the
select to select distinct but the problem is that my client sometimes wants
to send one email or one mailing to everyone who is on a committee. When she
just wants to send to one committee, it's not a problem -- only when it's to
all of them. I'll let you know if that solves the problem. Thanks.
 
N

Nancy

Thanks Brian. Just doing the query on the query and leaving out the cmte
field did the trick. I think I knew that somewhere back there but forgot it.
It is really nice to have this place to get answers to kinky little problems
like that.
 
Top