Filter same values in listbox

[schalkse]

Hi,

I have a table with training records. Each attendee is listed with date and the related document he was trained on.
Now i want to make a listbox where the user can choose between the different dates of the trainings. Now when several people where trained on the same day, i get some dates back multiple times in my listbox. When you had 100 on the same day, 100 times the date in that listbox. Is there a way to filter out the same dates and show each date only one single time in my listbox?

Thanks

 

[ColinEssex]

Use a totals query driving the ListBox, then the "GroupBy" will only show one value for each.

Col

 

[schalkse]

Use a totals query driving the ListBox, then the "GroupBy" will only show one value for each.

Col

Tried that before, but nope, still getting all the same result.

 

[neileg]

Open the query in design view, open the Properties box for the query and set the Unique Values parameter to Yes.

Or amend the SQL to Select Distinct instead of just Select.

 

[schalkse]

thanks man!