I have a query that I am running based on one of the fields in the table. I don't want to rely on users to enter the date in the correct format so I have it set to create a list box with the values found in the field but since it is a date field, I have many duplicates. How can I filter the list box values so that each value is only listed one time?
i.e. Field contains 26-May-09, 26-May-09, 26-May-09, 25-May-09, 25-May-09, 24-May-09
List box would contain: