Suppress Duplicates

[Bill]

I have a combo box whose row source
is a field from a query and is sorted on
that field. It is a normal case that the field's
contents are duplicated. I.e., the combo
display would contain duplicate successive
rows.

Is there a provision in SQL where I can
suppress duplicates? (either in SQL view
or design sheet view)

Thanks,
Bill

 

[Bill]

I found it. I had to manually insert "Distinct"
after Select in the row source of the combo's
property sheet. I couldn't find how to do the
equivalent via the design grid view.