Check out BINTOC()

You could index on:

ItemNumber + BINTOC(-AccountNumber)

With BINTOC() you don't have to worry about the size of your Account Number

>Thanks John,
>
>Yes that should work great because I want the Account# to be in reverse order and it is an integer field.
>
>Thanks,
>Paul
>
>>Paul,
>>
>>There are ways. If, for example, your item number structure is "nnnn" and your customer ID is "nnn", then the index tag could be:
>>
>>customerID+("9999"-itemno) for ascending customers and descending items within customer.
>>
>>Does this help?
>>
>>
>>>I was wondering if it was possible to create an index on 2 fields where one field is in ascending order and the other is in descending order?
>>>
>>>For example, I would like to list items order by customer. I would like the list to be in alphabetical listing by item# and then within each item# I would like the list to be ordered in reverse Account# order.
>>>
>>>Thanks,
>>>paul