Drop Box

[MAD101]

I have a drop down box in my database but it shows every entry that is in
that field. I have it to where it is drop box for the plant number, but
instead of showing the plant number once it shows every entry. If I have 100
entries and 50 are plant number 27 and 50 are plant number 85, there are 100
numbers in the drop down box with 50 27's and 50 85's. I want it to only show
the same plant number once. How do I do that. Did I do the drop down box. Can
some eone please tell me how to do this drop box from start to finish please?

 

[Arvin Meyer [MVP]]

Use the DISTINCT keyword:

Select Distinct [Plant Number] From My table;