Hi Bhav
Not sure how detailed this is. For instance, are you checking every field in one rec against every field in all others, or just certain fields?
Whatever, you may find the INDEXSEEK() function useful. It allows you to seek data in the same table without moving the record pointer from the current record.
Howver, the fields you seek DO have to be indexed of course.
HTH
Terry
>Hi all
>
>Maybe I am growing old but is there an easy way to compare records from the same table for differences, rather more like a list of differences. I have to get the non-tech/low-tech to compare select data for such differences thus the need for a utility.
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.