Eliminate duplicates in a Query

[Coco50]

I've run a query that captures the data set I want. Now I want to eliminate duplicates and retain only the unique names. What text is required in the criteria box in design view?

 

[cookiegary01]

Hi,
Have you tried the Sigma sign (Totals) in the design of your query?
Here you can group and or total on each field.

 

[Coco50]

Hi...thank you for your response. I tried the totals button, group by but it did not eliminate the duplicate values. To explain a little better I have a group of manufacturers that have multiple products, which means the manufacturer is a appearing multiple times. I want the manufacturer to appear one time regardless of the number of products each have.

 

[Pat Hartman]

Then you can't select the product column in the query. In fact, you shouldn't even be including the products table in the query unless you want a count of the products supplied by each manufacturer.