query to return 1 value out of many on a single table

[Guest]

I have a table that has a column that identifies supplier. It resides in a
table that is a parts list. I'd like to perform a query that would give me a
list of suppliers in the table. There may be 1000's of parts from the
supplier, but I'd like result to show 1 reference to the supplier field.

 

[Douglas J. Steele]

SELECT DISTINCT Supplier FROM MyTable

To do this through the graphical query builder, look at the properties for
the query. One of them is Unique Values.

 

[Guest]

worked like a charm. somehow, I had a feeling it would be simple. Thanks