FYI, the STR() will drop the decimal portions unless you tell it how many places to use. Use TRANSFORM(col1, '9999999.999') with a mask that's large enough to hold the data to be sure you get the proper index.
Cathy
>Hello,
>
>I am trying to make a index on 2 fields. The index needs to sort by the first column and the second column and they are both numberic fields.
>
>With this index I want to set a key for a quick reference and exlude certain values in the second column.
>
>Example:
>Set key to 12.222,12.222
>
>Any direction on how to setup this index would be appreciated.
>I am currently using Str(col1)+str(col2) but I am having trobles exlusing the records that don't match a column2 criteria.
>
>Thanks,
>
>Jeff