Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing Duplicates Only

Status
Not open for further replies.

SJSUHSG

Technical User
Apr 5, 2005
3
US
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.
 
Please provide some detail and sample data of what you are currently getting, and what results you would like to obtain.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top