Printing Duplicates Only

[SJSUHSG]

Hello, I want to print the records which are duplicates based on a Primary Key,if the key is duplicated I want to print the record with its each occurance.

I tried grouping by Key and then taking a count of each group and then including all Count>1. This trick works if I just want to see which records are duplicated. It shows each duplicated record only one time. However, I want to see its every occurance where information might be same or might be different in each field for that record.

I basically want to do what Access does with find duplicate query.

Can somebody help me with this.
Thanks.

 

[MJRBIM]

Please provide some detail and sample data of what you are currently getting, and what results you would like to obtain.

 

[bdreed35]

Do exactly what you have done so far:

Group on the Key field, create a count of records per group, and then in the Select Expert, put the criteria that the subtotal count > 1.

After that, place all the fields you wish to see in the details section.
Suppress the group header and footer.

~Brian

 

[SJSUHSG]

Thanks Brian,
Your solution worked.