>>Hi Claude
>>>1. Why does table Tx have fewer records then table x?
>>
>>The original table has deleted records. So, they are not missing. You can use count function to see how many active records are in the original table.
>>I bet you will have the very same number with select statement
>>
>>>2. What is the best way to find what records are missing?
>>
>>DO you need deleted records too?
>
>I think so. It would be the safest way to go.

Thanks that was it. I save current value of "Deleted", set "Deleted" to OFF and then reset it.