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

W

wes k

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.
 
D

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.
 
Top