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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Table-based report, grouping by fiscal year 2
Grouping/Sorting by Date 4
Count Unique Records 4
Sorting and Grouping 2
Trouble with my sorting and grouping 2
Sorting & Grouping Problem 4
Sorting within grouping 3
Sort Report by Month 1

Back
Top