>>Bonnie,
>>
>>Here is the message, which confirms my original suggestion:
>>
>>Forum: Visual FoxPro Category: Coding, syntax & commands Title: Re: Scan...Endscan Thread #374171 Message #374418
>
>If there's index order set on the table foxpro has to use that index in SCAN to find next record regardless if there is or not WHILE !EOF(). The only difference WHILE !EOF() clause makes that SCAN starts processing from the current record in table not from the top.

I guess, now I have to run couple of tests to confirm or deny the original statement. I'm in the middle of something, but hopefully will have time in the evening...