combo box

[Guest]

Anyone,
Why is it that if you have a combo box pulling info from a table which has
duplicate items in a column...that you will have the same duplicate number in
the combo box? Is there a way to just have one instance of an item come up
in the combo box and the info is ran from there? ie...if I were to have
apples 5 times, oranges 3 times, and bananas 2 times on a table, it would
come up those multiple times in my combo box. How can I elimate those
multiples?

Thanks in advance
Rose

 

[Kevin Sprinkel]

Hi, Rose.

Change your SELECT statement to SELECT DISTINCT. If you
need help with the syntax, create a query in Query By Grid
view, change the query's Unique Values property to Yes,
then switch to the SQL view.

HTH
Kevin Sprinkel