Sort Order

[Jess]

Right now I have a report that is sorting in a desending
order. However, when I add summary options to the report
footer, it no longer sorts correctly. Any recommendations
on how to get the report to sort correctly and summarize
fields in the report footer?

 

[Marshall Barton]

Right now I have a report that is sorting in a desending
order. However, when I add summary options to the report
footer, it no longer sorts correctly. Any recommendations
on how to get the report to sort correctly and summarize
fields in the report footer?

Specify your sorting field in the Sorting and Grouping
window. Sorting the record source query only works in the
most trivial reports.