Hide Duplicates from Find Duplicate Query

[cooh23]

Hi All,

I am having some problems hiding the results from a duplicate query.
what happens is that I find all of the duplicates using the find duplicate query, but it counts it twice as it shows all duplicate items.

how can i re-write the query below to only show the duplicated entries once.
I have tried show Unique Values and Unique records, but it wasn't working.

here's my query:

SELECT Sheet1.AgentName, Sheet1.AgentSSN, Sheet1.Source, Sheet1.State
FROM Sheet1
WHERE (((Sheet1.AgentName) In (SELECT [AgentName] FROM [Sheet1] As Tmp GROUP BY [AgentName] HAVING Count(*)>1 )) AND ((Sheet1.State)="AL"))
ORDER BY Sheet1.AgentName;

 

[maxmangion]

add the word DISTINCT after the Select word.

 

[cooh23]

add the word DISTINCT after the Select word.

Hi,

Unfortunately, this didn't work. I don't know what else could be the issue.

Selecting YES for unique values under the query properties doesn't do anything either.