Ordering in a Report

[Tracy]

Hi,

Does anyone know if you can order on anything other than a field in a report. Basically I want to order by a calculated field, but it won't work. Instead I have to order by a field that is in the record source of the report.

This is no good because the thing I sort on changes and has 20 different possibilities, so I don't really want to add 20 extra calculated fields to the qry that the report is bound to.

Any Ideas?
Cheers
T

 

[Autoeng]

Maybe you should post this in the Reports forum.

 

[Tracy]

Nope, I put everything here, much easier. How about an answer to the question? Maybe?