[AccessD] problem sorting in group

You know, this sounds really familiar -- I'm betting I've seen this before 
and just forgotten. Thanks.

Susan H.


> 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.
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com