ACC: Query Sort Ignored When You Add Field to Report Footer
ID: Q141885
|
The information in this article applies to:
-
Microsoft Access versions 1.1, 2.0, 7.0, 97
SYMPTOMS
Novice: Requires knowledge of the user interface on single-user computers.
When you base a report on a query that has a sort order defined, the sort order is retained in the report. However, if you add a field to the report footer, the sort order from the query is no longer used.
CAUSE
Reports use their own internal queries. They are not designed to use a
query's sort order. The fact that a query's sort order is maintained in a
report without the calculated field in the report footer is by chance.
RESOLUTION
Define your report sort order in the report's Sorting And Grouping dialog
box.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database Northwind.mdb (or NWIND.MDB in versions 1.1
and 2.0).
- Create a new query based on the Orders table.
- Add the OrderID, ShipCity, and Freight fields.
NOTE: In versions 1.1 and 2.0, there is a space in the Order ID and in
the Ship City fields.
- For the ShipCity field, set Sort to Ascending.
- Close and save the query as Query1.
- Create a new report based on Query1.
- Add each of the fields from Query1 to the report's detail section.
- Preview the report. Notice that the report is sorted by ShipCity.
- Add a text box to the report's footer section. Set the ControlSource
property to =Sum([Freight]).
- Preview the report. Notice that the report is no longer sorted by
ShipCity.
REFERENCES
For more information about sorting in a report, search on the phrase
"report sort," then "sorting," and then view the "Change sorting and
grouping order in a report," topic, using the Find option in the Microsoft
Access for Windows 95 Help menu.
For more information about sorting in a report, search on the word
"reports," then "grouping data," and then view the "Changing Sorting and
Grouping Order," topic, using the Microsoft Access 2.0 Help Index.
Additional query words:
Keywords : kbusage RptSort
Version : WINDOWS:1.1,2.0,7.0,97
Platform : WINDOWS
Issue type : kbprb