[AccessD] problem sorting in group

Susan,

    As soon as any setting is made via Sorting and Grouping dialog box, existing sort order (if any) in the source query gets ignored.

    Your problem should stand resolved by adding the date field explicitly as the last item in first column of this dialog box (and selecting Ascending or Descending in second column as desired).

Best wishes,
A.D.Tejpal
------------

  ----- Original Message ----- 
  From: Susan Harkins 
  To: AccessD at databaseadvisors.com 
  Sent: Monday, October 15, 2007 00:23
  Subject: [AccessD] problem sorting in group


  I've got a simple report grouped by a date field using the Week Group On 
  setting. However, the dates within each group aren't sorting, even though 
  I've set an Ascending sort both via the Sorting and Grouping feature and in 
  the underlying query.

  Year values are the same, but only one group is sorting as expected -- 17 
  July, 18 July, 19 July, and so on. All the others are just skipping 
  around -- 19 July, 18 July, 15 July, 16 July, 17 July.

  I don't understand why the dates are sorting correctly within the groups.

  Susan H.