>>>>I want to index a file on descending order of fields 1 and 2 but within that on ascending oder of fields 3 - how can I do this?
>>>>I have tried this but it doesn't work
>>>>index on dupkey+codex DESCENDING, COPYNO ASCENDING TAG docky
>>>
>>>IF COPYNO is an integer, you can try something like
>>>
>>>index on dupkey+codex + Cast(2^31-1-COPYNO AS M) DESCENDING TAG docky && updated 'C' to 'M'
>>
>>Sadly Copy No is an alpha field it contains Copy No 421 for example
>
>There's always a solution with VFP!
>
>index on dupkey+codex + Cast(2^31-1- Cast(strtran(COPYNO, chrtran(COPYNO, '0123456789', '')) AS I) AS M) DESCENDING TAG docky
Thanks I will try it
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing