>Hi Fred,
>
>>>>By the way FoxAudit Archive routine is VERY strange. It seems to eliminate records from NOW to a entered date rather everything PRIOR to the entered date wich would make a lot more sense.
>>>
>>>I just purchased FoxAudit and was surprised by this also...have you ever made sense of it? i have to explain it to my client!!
>>>
>>>J
>>
>>Could you possibly have changed an index tag on a FoxAudit table from ASCENDING to DESCENDING? (or posibly DESCENDING to ASCENDING)
>
>I haven't changed anything in any FoxAudit table as far as I know...but I'll check anyway (I'm not on my home computer at the moment). Thanks for the idea.
>
>Are you using FoxAudit, and have you observed different behavior than described above?

No, I don't use FoxAudit, but from my own personal experience, I've witnessed a change in the tag's direction affecting my code in a similar matter to what you describe.