In ComboBox Stop Repeated Data

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

Guest

I have a combo box that uses a query to select the a field called anaylsts.
My problem is that it lists each one....so Greg Smith can be listed 12 times.
Therefore I would like it to retrieve that Names but only have them listed
ounce in the drop down box. I think that when I made the query there might be
a non-duplicate expression?

Anyhelp thanks!
 
Switch to the SQL View of your query (View | SQL View from the menu), and
add the word DISTINCT after the word SELECT.
 
Duh!, Thanks a lot

Douglas J. Steele said:
Switch to the SQL View of your query (View | SQL View from the menu), and
add the word DISTINCT after the word SELECT.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox 1
Valuelist in Combobox 2
Valuelist in Combobox 1
Show all Records 1
Hide Duplicated Data in ComboBox 6
Newb Form/Combobox Expression Question 2
Newbie: Getting combobox to show new data in list? 4
Data Entry to Form with repeat data. 13

Back
Top