dsoderstrom
asked on
Problem with sort order on access report
In Microsoft Access I have a report that has a Select Query as a Data Source.
The Select Query is sorted on the Item Number field. When I run the Select Query it displays in Item Number order as it should.
But, when I do a Print Preview of the report based upon this query it is not in Item Number order. There are no Groups, Sorts or Totals defined within the report and there is nothing in the Order By property on the Data tab.
Why would the report not print in the order specified by the Select Query?
The Select Query is sorted on the Item Number field. When I run the Select Query it displays in Item Number order as it should.
But, when I do a Print Preview of the report based upon this query it is not in Item Number order. There are no Groups, Sorts or Totals defined within the report and there is nothing in the Order By property on the Data tab.
Why would the report not print in the order specified by the Select Query?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER