Dates in Chronological Order

  • Thread starter Thread starter Penny
  • Start date Start date
P

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
 
Penny said:
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.
Click to expand...

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