How to query for unique values

[Dan]

I have a table with a field for Vendor. There are 60K line items in the
file. But only 30 vendors. So each vendor is repeated many times.

I want to build a query that will list each vendor only once. How would I do
that? Is there a built in function that I place in the criteria to only
return one value for each?

Dan

 

[Randy Harris]

I have a table with a field for Vendor. There are 60K line items in the
file. But only 30 vendors. So each vendor is repeated many times.

I want to build a query that will list each vendor only once. How would I do
that? Is there a built in function that I place in the criteria to only
return one value for each?

Dan

SELECT DISTINCT Vendor FROM Table;