How to get rid of Duplicate Value in Query Access

[Amazing1984]

How can i get rid of Duplicates from Access query, i just want to get unuiqe values out of my query. If there is code or something add up that can get rid off, Please Post.

 

[ChesterKaup]

Open the query in design view. Right click in the area at the top of the page where the table names are displayed. Select properties from the drop down list. Set unique values to yes.

 

[Amazing1984]

Thank you.