Access Combo Box Question 1

[ccepaulb]

I have a combo box that references a data table field. Within this field I have multiple brand names in a list format. What I want the combo box to do is only show one value, instead of all of the same values within the field.

for example...I may have 400 references to Brand A, 500 refs to Brand B. Instead of showing Brand A 400 times, and Brand B 500 times, I just want two values to show up in the combo box; Brand A (1 time) and Brand B(1 time)

How would I do this?

Thanks, Paul

 

[BenUK]

SELECT DISTINCT [BrandField] FROM [BrandTable]

 

[ccepaulb]

Perfect...Thank you!