Dates in Chronological Order

[Penny]

I have a report that is sorting and grouping by a field
name of [Trade Date]. I have my first grouping by [Trade
date] and group on qtr. My second grouping is by [Trade
Date] and group on month. I have grand totals for by month
and quarter. They are working great. I just can't get the
dates in my grouping by month to sort in chronological
order. Any ideas?


Thanks in advance

Penny

 

[Marshall Barton]

I have a report that is sorting and grouping by a field
name of [Trade Date]. I have my first grouping by [Trade
date] and group on qtr. My second grouping is by [Trade
Date] and group on month. I have grand totals for by month
and quarter. They are working great. I just can't get the
dates in my grouping by month to sort in chronological
order.

Add a third level of sorting by using just Trade Date on
each value.