[AccessD] report sorting problem

Susan Harkins harkinsss at bellsouth.net
Wed Mar 22 08:02:57 CST 2006


Thanks -- that does seem to be the case -- adding the DateDue field to the
sorting group as a lone sort did the trick. :) It's a bit of a nasty gotcha.
I think Access folks either work a lot with reports or almost never touch
them -- I'm in the latter group. :) 

Susan H. 
 

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




More information about the AccessD mailing list