Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing question
Message
 
To
25/01/2000 12:18:02
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00322258
Message ID:
00322269
Views:
24
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
Map
View

Click here to load this message in the networking platform