Used Thomas Edison approach and found empirical solution.
Just add another sort to the report. I sorted on Pct first, then Team.
Sorting in a Report
Excess Access
Windows 11 
Access 2021
Used Thomas Edison approach and found empirical solution.
Just add another sort to the report. I sorted on Pct first, then Team.
Very Inert Person
Windows 10 Access 2016
In post 13 it looks as though it's sorted on 3rd field from left.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
VIP
Windows 7 64bit Access 2010 32bit
Originally Posted by davegri
Used Thomas Edison approach and found empirical solution.
Just add another sort to the report. I sorted on Pct first, then Team.
Wow that works don't know why it works but it does.
VIP
Windows 7 64bit Access 2010 32bit
No it's sorted on PCT If you look at the sort option at the bottom of the screen it shows PCT. Funny thing is if I add the Team Sort it works and sorts correctly. which I don't get at all. but it works so I'm good. Thanks everyone for your help.
sorting and grouping not sorting in reports
sorting a field in report
Posting Permissions
Reply With Quote