Ellis,
Check
Re: Creating a compound index with a descending portion Thread #
1053896 Message #
1053916>
>I have a table with character fields A, B & C
>
>I need to create an index on A (ascending) + B (descending) + C (ascending) to display in a grid:
>
>Apple | Mac | New Hampshire
>Apple | Mac | Washington
>Apple | Granny | New Hampshire
>Apple | Granny | Washington
>Apple | Delicious | New Hampshire
>Apple | Delicious | Washinton
>
>What index expression can I use to accomplish this?
>
--sb--