Query Result Duplicates

[AliceN]

I have a database that lists media contacts, the regions they are from and
the different categories of media releases they have signed up to receive. I
have queries that allow you to search on release category or region or both.

The problem I'm having is that when I search on two or more categories,
anyone who is signed up to more than one of those appears in the results more
than once. I have inserted the Totals line and set it to group by First in
the categories column of my query but this seems to have turned an OR query
into an AND query - it now only returns people who have signed up to all of
the categories selected.

Any suggestions would be greatly appreciated.

 

[Jeff Boyce]

If you are only looking for the media contacts (and not the categories
they've signed up for), you could use the properties of the query to get
Unique Values. That way, each contact would only show once (provided your
query is ONLY returning the contact).

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

 

[John W. Vinson]

I have a database that lists media contacts, the regions they are from and
the different categories of media releases they have signed up to receive. I
have queries that allow you to search on release category or region or both.

The problem I'm having is that when I search on two or more categories,
anyone who is signed up to more than one of those appears in the results more
than once. I have inserted the Totals line and set it to group by First in
the categories column of my query but this seems to have turned an OR query
into an AND query - it now only returns people who have signed up to all of
the categories selected.

Any suggestions would be greatly appreciated.

For one thing, don't Group By the category or region fields - instead use the
Where "totals" operator (which will uncheck the "show" checkbox).

John W. Vinson [MVP]

 

[AliceN]

Thanks. I was hoping to be able to show the categories as well, but I guess
my users will know what they've searched for so it shouldn't matter.

Will this still work if I have it return the contact's name and their email
address but not the categories?