Thanks for the quick answer - I suspected, but wasn't sure
>A bad index can give this result. With matching index expressions SQL works with the indexes to find out which records to work with, and then work with the actual tables.
>
>>Has anyone seen a case where a corrupt index has affected SQL results?
>>
>>We've got a case where a client has 2 appts for the same day, yet when the lookup is run with a date filter only one shows, if no date filter is used, both show up.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place