>A while back I asked for help in finding duplicate records. I've worked this job for a week and I have better information to give. This is an auditing application. First, there are several million records in the table. The auditors want to look for records where several of the fields either match or maybe values were transposed (like vendor number and transaction number or invoice number). They want to search the table an only return a set of records where there are not just unique records (one of everything), but where two or more records meet the criteria. Suggestions?
I guess it's time for a shameless plug... ;)
If you look in the Files section of the Universal thread, you'll find a file I wrote called DupCheck.exe. I believe you'll find that this program will do the kind of extraction you are looking for. Its only requirement is that the VFP 5.0 development package or runtimes must be installed on machine in advance - I didn't write a setup routine for the distribution.
Let me know what you think - I'm taking suggestions for a new release of it.