OK
How about opening the table again, under a different alis. Loop through one of them. At each rec do a select-SQL for the "difference" on the other incarnation of it, accumulatively appending your result cursor to a report cursor?
HTH
Terry
>Hi Terry
>
>Thanks for your quick response to my post.
>
>>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?
>
>Unfortunately, it is all fields. Sound overkill but I cannot rely on their judgement of deciding which fields are important.
>
>>Howver, the fields you seek DO have to be indexed of course.
>
>That will be the true overkill *g*
- 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.
