ACC1x: Negative GroupOn Interval Reverses Sort Order

Last reviewed: May 28, 1997
Article ID: 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

  1. Open the sample database NWIND.MDB. Create an new report based on the "Order Details" table.

  2. 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
    

  3. Drag the Order ID field from the Field List box onto the report.

  4. Preview the report. Note that the sort order is descending.


Additional query words: date time numeric
Keywords : kbusage RptSort
Version : 1.0 1.1
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.