A.D.TEJPAL
adtp at airtelbroadband.in
Tue Mar 21 23:59:10 CST 2006
Reports - Sort Order
===============
Results displayed by a report comply with the sorting specified in the source query only if no GroupLevel has been laid down in report design (via Sorting & Grouping dialog box).
As soon as you lay down even one GroupLevel, the sort order indicated therein over-rules the sorting (if any) in source query. Moreover, it then becomes necessary to explicitly set up other GroupLevels (in the hierarchy) as well - if any secondary sorting is desired. For this purpose, you can no longer depend upon the source query.
A.D.Tejpal
----------------
----- Original Message -----
From: Susan Harkins
To: 'Access Developers discussion and problem solving'
Sent: Sunday, March 19, 2006 23:57
Subject: Re: [AccessD] report sorting problem
Hmmmmmm... Tried it and that alone didn't work. I added a second group on DateDue and that did it -- thanks Gustav.
Susan H.
<< SNIP >>