Getting Rid of Duplicates

S

Sky Warren

Hello All,

I have a combo box that's filled with values from a table. The field in
question is named "Producer" and that field has loads of duplicate names in
it.

Is there a way to limit the combo box list to show just unique names?

-Sky
 
A

AlCamp

Sky,
In the properties for the query, set Unique Values to YES.
Or, you could do a View Totals query, and use the Group by on your field.
hth
Al Camp
 
Top