General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only