Sorting dates within groups.

  • Thread starter Thread starter Frank Martin
  • Start date Start date
F

Frank Martin

I have a RptStatement to send to customers
each month.

I have grouped the data by month on the
InvDate field.

But the dates (InvDate) within a group are in
descending order, even though the setting in
the "Grouping and Sorting" box has them in
ascending order.

Please help me how to fix this. Regards,
Frank.
 
Add InvDate to the Sorting And Grouping dialog a 2nd time.

The first instance tells Access to sort the months grouping ascending. The
2nd instance tells Access to sort the dates within the grouping.
 
Back
Top