Sorting dates within groups.

[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.

 

[Allen Browne]

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.

 

[Frank Martin]

Thanks, this worked.
Who would have believed it!?


"Allen Browne" <[email protected]>
wrote in message