Display only one record of each!

[Cesar Urquidi]

Hello,
I have a query of products with suppliers, and I want to display only one
record of each.

What do I need to enter on the "Supplier" field as the criteria???

 

[Wayne-I-M]

SELECT DISTINCT TableName.Yourfield
FROM TableName;

 

[Cesar Urquidi]

Thank you Wayne... It worked just like I wanted it to!!!