ACC1x: Negative GroupOn Interval Reverses Sort OrderLast reviewed: May 28, 1997Article ID: Q100130 |
The information in this article applies to:
SYMPTOMSWhen 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.
RESOLUTIONThis 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
|
Additional query words: date time numeric
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |