Row Source Question

[Huey462]

I have a report that contains a dropdown menu to allow the user to filter out unwanted information. I have a list built with pre-determined values/positions. What I had hoped to do was change the SELECT from the default list to a list of values contained in the form’s table. So if there were only two shops on the report, the user wouldn’t have to pick from a list of 20, only the 2 would be displayed.</SPAN>

Original SOURCE:</SPAN>
SELECT [tblOffice].OfficeSymbol FROM tblOffice ORDER BY [tblOffice].OfficeSymbol;</SPAN>

This would result in a list of shops like the example below:</SPAN>
[Blank]</SPAN>
Shop A</SPAN>
Shop B</SPAN>
Shop C</SPAN>
and so on</SPAN>

Modified SOURCE:</SPAN>
SELECT [tblToDo].OPR FROM tblToDo ORDER BY [tblToDo].OPR;</SPAN>

This would result in a list of shops like the example below:</SPAN>
[Blank]</SPAN>
Shop A</SPAN>
Shop A</SPAN>
Shop B</SPAN>
Shop B</SPAN>
Shop B</SPAN>
and so on</SPAN>

My question is this: is it possible to remove duplicate listings of the same shop in the second version?</SPAN>

 

[pbornemeier]

If it behaves like other SQL,
SELECT DISTINCT [tblToDo].OPR FROM tblToDo ORDER BY [tblToDo].OPR;
should work

 

[Huey462]

Exactly what was needed. Thank you very much!

 

[Joe4]

SELECT DISTINCT is valid syntax in Access, so it should work.
Alternatively, you could also do an Aggregate Query, where you Group the records, thus weeding out the duplicates.