Identifying duplicate records using alias tables 1

[hannahkitty]

Hello - I am working on a report to identify duplicate records where a number of fields must be duplicated to qualify as a dup record. The primary table has links to secondary tables. I set up an alias of the table with the dup fields, but the data returned is not quite right (i am getting non-dup records as well as dups)

any suggestions? I can make this in Access no problem!

 

[dgillz]

No need for an alias. If the records are all in the same table, and lets say fields A,B, D and F are the ones that determine a duplicate record. Concatenate the four fields in a formula, and group on the formula with a count summary. Then do a group selection formula where the count of the formula fields is greater than 1.

There are your duplicate records. Determine whihc ones to keep and which ones to discard.

Software Support for Sage Mas90, Macola, Crystal Reports and Goldmine

 

[hannahkitty]

That totally worked. Thank you so much! I'll save that method in my 'simple solutions' folder.

cheers!