sorting in a report

[sasoderl]

I need help. I have a report that is based on a query. The query sorts on what I want it to sort on, however one of the fields that I require the query to be sorted on is not in the report. But, I need my report to still be sorted on that field. If the query is the record source for the report, then why does the sort order change when the report is opened???

 

[bat17]

Reports will override query sorting, try adding you field to the report but set it to visible false.

peter