I have a query that is the datasource for a report. When I run the query and look at the data the criteria to sort by Payment (descending). When I run the report, it's sorted alphabetically by person's last name and doesn't sort by Payment. See screenshots.
The button that calls the report is very simple:
Dim stDocName As String
stDocName = "rptRegistration"
DoCmd.OpenReport stDocName, acPreview
I also checked to make sure the Report doesn't have code on the OnLoad that would sort.
Where else could I look to find filters that would be overiding my report sort order?