>We wen 'round and 'round with this when I posted about the index problem. There's nothing wrong with the index, it just sometimes doesn't find it. For example, there's an index that puts the billing reports in order of their paysource. She ran it once and they were all out of order. She ran it again and they were in order.
>
>
What did 'She' run? If you SET ORDER TO paysource, the table is in order by paysource. If the Index is not there, you will get an error when you attempt to set the order.
Wayne
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown