How to show duplicate records only

[tacoboy42]

i need a report that will show all duplicate records in a certian feild, if anyone can help me with this i would aprecitate it.

 

[Brianwarnock]

Isn't there a find duplicates query wizard?

Brian

 

[tacoboy42]

i dont know, im using Access 2003 and dont see that option.

 

[Brianwarnock]

It's there in 2002, can't imagine it disappearing in 2003

Brian

 

[tacoboy42]

Ah, Found it! Im new to access, was looking in the wrong place....Thank you!

 

[KeithG]

Access 2003 has this feature, to use all you have to do is choose New from the query tab.