Microsoft KB Archive/100130: Difference between revisions
From BetaArchive Wiki
(importing KB archive) |
m (Text replacement - """ to """) |
||
Line 42: | Line 42: | ||
<ol> | <ol> | ||
<li>Open the sample database NWIND.MDB. Create an new report based on the | <li>Open the sample database NWIND.MDB. Create an new report based on the "Order Details" table.</li> | ||
<li><p>From the View menu, choose Sorting And Grouping. Select Order ID for the first field. Fill out the Sorting And Grouping box as follows:<br /> | <li><p>From the View menu, choose Sorting And Grouping. Select Order ID for the first field. Fill out the Sorting And Grouping box as follows:<br /> | ||
</p> | </p> |
Latest revision as of 13:29, 19 July 2020
ACC1x: Negative GroupOn Interval Reverses Sort Order |
Q100130
The information in this article applies to:
- Microsoft Access versions 1.0, 1.1
SYMPTOMS
When a nontext field on a Microsoft Access report is sorted in ascending order and is grouped on an interval, the sort order will be descending, not ascending, if the interval is set to -1.
RESOLUTION
This behavior is by design. With the interval set to -1, the report is sorted on the negative result of the expression or interval.
MORE INFORMATION
Steps to Reproduce Behavior
- Open the sample database NWIND.MDB. Create an new report based on the "Order Details" table.
From the View menu, choose Sorting And Grouping. Select Order ID for the first field. Fill out the Sorting And Grouping box as follows:
Sorting And Grouping -------------------------- Field/Expression: Order ID Sort Order: Ascending Group Properties ------------------ Group Header: Yes Group On: Interval Group Interval: -1
- Drag the Order ID field from the Field List box onto the report.
- Preview the report. Note that the sort order is descending.
Additional query words: date time numeric
Keywords : kbusage
Issue type : kbprb
Technology :
Last Reviewed: November 4, 2000 |