I have a report with calcs in the footer. When I use
Me.RecordSource = "qryXYZ", A2K2 seems to ignore the "Order by" component of the SQL (all other statements in the query work properly). When I remove the footer entirely, it sorts properly. There are no Sorting and Grouping statements in the report.
I would really like to control the sort sequence within the Me.RecordSource statement.
Anyone seen this problem before? Any ideas on a workaround?
That seems a roundabout solution, but will probably work. Do you have any idea why it is ignoring the sort criteria? I understand why if one uses Sorting and Grouping within the report, but it doesn't make sense with just report footer totals etc.