Question: access do not show duplicates in query?
Answer: In the Navigation Pane, right-click the table that contains the field, and then click Design View. Select the field that you want to make sure has unique values.