Query That Filters Duplicates

  • Thread starter Thread starter Karl Burrows
  • Start date Start date
K

Karl Burrows

I have a query for a newsletter database that only includes members in
certain local categories. The problem is, members may belong to several
categories. When I run the query, they show up multiple times, but only
need to show once if they are in any of the categories.

How can I create the query to look at all the categories, but only include a
member once?

Thanks!
 
Actually figured out the answer! I removed the category field from the
query view, added the primary key as a unique identifier and then changed
the properties to show unique records.

Maybe someone else can use this info or know of a easier way to do it.

Thanks!

I have a query for a newsletter database that only includes members in
certain local categories. The problem is, members may belong to several
categories. When I run the query, they show up multiple times, but only
need to show once if they are in any of the categories.

How can I create the query to look at all the categories, but only include a
member once?

Thanks!
 
I get an error if I try to use SELECT. Isn't that a SQL command? How do I
add it to the query?

SELECT DISTINCT will also do the same thing
 
Back
Top