In MS Access, how do I prevent redundant entries in a combo box?

Question

I made a combo box in a form. Under the properties, under "row source" I have "SELECT Column1 FROM Table1" - This works properly in displaying all items under Column1 in the combo box. Unfortunately, a large portion of the data is redundant. How can I get the combo box to only display one of each different piece of data?

Answer 1

Try SELECT UNIQUE Column1 from Table1