Use Query as a Rowsourced Table Without Duplicates

[raychow22]

Hi Forum,



Is there a way to use a Query as a Rowsourced Table for a List on my Form without Duplicates? Currently, in my Form, there is a rowsourced qrTableList; however this list is generated from my main backend Table. The problem is that it shows duplicates because they are allowed to have them; but I just want a list without the duplicates. Is there something I can write into the Query to not show duplication?

Thanks,

Raymond

[CJ_London]

SELECT DISTINCT or use an aggregate query (group by)

[raychow22]

Thanks Ajax!!