>Thanks Naomi. I think I found the problem. The expression for the index is complex (LEFT(loc_id,1)+STR(VAL(RIGHT(loc_id,6)))) so it was a simple matter of reindexing on just the loc_id field.
>
>Isn't it a pain getting old?
Good you found the problem.
If it's not broken, fix it until it is.
My Blog