ID Double Records

[ITbeast]

Can someone think of a quick query that I could use to identify when a value shows up more than once in a table? The aren't necessarily duplicates, I'm just interested in one field that that value shows up more than one. I realize that I could sort the column and view them that way, but I want a nice looking list of them.

 

[rjoubert]

SELECT YourTable.YourField, Count(YourTable.YourField) AS CountOfField
FROM YourTable
GROUP BY YourTable.YourField
HAVING (((Count(YourTable.YourField))>1));