Create Report of Duplicates

[John P]

My DB has one table for completions, which can have duplicate records (we want to report the duplicates). I need to create a report of all records (field to identify duplicates is called control number) that are duplicates. What does my expression need to look like to produce this result? I think I could simply say control number = control number, but that returned all records. Any suggestions are greatly appreciated. Thanks

 

[Dugantrain]

Probably the easiest way would be to use the Find Duplicates Query Wizard and then base your report off of that query.