Getting Rid of Duplicates

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

Guest

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