Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Indexing question
Message
From
25/01/2000 12:55:28
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00322258
Message ID:
00322287
Views:
17
In that case, Paul, the tag expression is a bit different. I was assuming a character field. What's interesting though, is that if you wanted to do this with names (let's say a 20 char field), "ZZZZZZZZZZZZZZZZZZZZ"-table.namefield would work as well.

>
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Reply
Map
View

Click here to load this message in the networking platform