Oops forgot the other part of the question.

Is it possible to make the field2 show in descending order.
like in:
select * from table1 order by nfield1 asc, nfield2 desc


???
Thanks