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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Finding Duplicates
- Thread starter saw15
- Start date
KamalKhalil
MIS
Saweens:
You have not specified what you are using, and you did not explain what you are going to do with the Duplicates.
Generaly, there are 3 steps to DETECT duplication.
1) Sort by the primary key.
2) Create a flag field.
2) Compare with the previous record, when duplicate, flag it ( example Flag field = 1)
Good Luck Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
You have not specified what you are using, and you did not explain what you are going to do with the Duplicates.
Generaly, there are 3 steps to DETECT duplication.
1) Sort by the primary key.
2) Create a flag field.
2) Compare with the previous record, when duplicate, flag it ( example Flag field = 1)
Good Luck Kamal Khalil
Sr. Client Technical Analyst
kkhalil@Houston.ds.adp.com
An alternate approach is to highlight the field that should be unique and select Insert Summary. Set the operation to "Count" and the Group Field to the same unique field. Click OK.
Now highlight the new subtotal and open the select expert. Put in a rule that says: Count of "xxxxxx" is greater than 1. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
Now highlight the new subtotal and open the select expert. Put in a rule that says: Count of "xxxxxx" is greater than 1. Ken Hamady
Crystal Reports Training/Consulting and a
Quick Reference Guide to VB/Crystal (including ADO)
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question