Forum Discussion

Copper Contributor

Dec 08, 2019

Populate Access ListBox with Distinct/Unique Values

I'm a CS student in my 4th year, my professor wont grade my assignment because i didn't populate a ListBox correctly (I got a 10/200 but i have an option to turn in 1 revision). The ListBox named "ls...

Copper Contributor

Dec 13, 2019

globz

Drop the tblProperty.PropertyID field so it looks like this:

SELECT DISTINCT tblProperty.PropertyType FROM tblProperty ORDER BY tblProperty.[PropertyType];