Query with duplicates

[therodzone]

I'm using a Query to sort a column in a table called TEAM NAME alpha, and there are duplicates which I do not what shown. For example: The TEAM NAME called ARI is in the table 20 times, but for the output of my query, I only want it to be listed once. How can I do this?

 

[sambo]

Hey thero,
That's so bizarre, I just came online to figure out the exact same question.
I guess we will wait for a reply together.

 

[sambo]

Found it,
Click on the grey area in query design view and open the query properties. Change Unique Values to "yes". This will only allow one entry per value to be displayed. This doens't help, however, if you have more than one field from any table in your query, which is unfortunately my case.

 

[sambo]

I just decided to create 3 seperate queries, that way I could choose unique values, this gives me two extra queries, but it worked so I went with it.

 

[therodzone]

Found it,
Click on the grey area in query design view and open the query properties. Change Unique Values to "yes". This will only allow one entry per value to be displayed. This doens't help, however, if you have more than one field from any table in your query, which is unfortunately my case.

Great, that sure did it. Thanks alot!