>>>I tried it, Fred...didn't work. Still get the same error when i want to run the report.
>>
>>Is your report using a private datasession? Change it so it doesn't.
>
>I didn;t use a private datasession when I created it

Hi I missed the beginning of the thread... but, you are using SQL select to table ? Then you want to index the table?

Try this...

select * from blah into table mytable

index on myfield tag myfield of mytable


The above should leave the last index you create as the active one, but you should be able to do...

set order to tag myfield

if that doesn't work, try..

set order to tag myfield of mytable

BOb