>>>I found the difference in indexes. One is in ascending order and one is in descending. They are used in the code - so not easy to get rid of them.
>>>Not sure why it was programmed this way.
>>
>>You can just SET ORDER TO [TAG] DESCENDING and SET ORDER TO [TAG] ASCENDING. You don't need two different indexes.
>
>I know that - but it seems to be in too many places. Or should I take the bullet here?
Your call. Multiple indexes never really bothered me unless I had to make changes to them. What's the odds you'll need to change what fields they are on?
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers