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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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