Sort a Report in an Order Below Grouping

[29949653]

Hi All,

I have a report that i have formed and i want to sort it by balance from highest to lowest. However, i have grouped the data names the refer to the balance. This means that the report automatically sorts the data in alphabetical order from the titles e.g

Contractor Performance
Training Issue £5k
Human Error £15k

IMSERVE Performance
Incorrect Estimate £12k
Caused Leak £28k

Therefore, i need the report to look at the balance and sort it accordingly.

Thanks for your help in advance

Ciaran

 

[hymn]

Go into Sorting and Grouping and change it to descending

Hope this helps
Hymn

 

[29949653]

Hi Hymn

This still wont make a difference as its only going to change the main grouping and not sort the report by value.

Thanks

Ciaran

 

[hymn]

have a look at OrderBy Property in Access help


Hope this helps
Hymn