I have a footer in my report totaling a count for an data field. I want to sort the report by the footer count to have the records with the highest count at the top of the report. How do I sort the report by a footer?
Advanced Beginner
Windows 10 
Access 2007
I have a footer in my report totaling a count for an data field. I want to sort the report by the footer count to have the records with the highest count at the top of the report. How do I sort the report by a footer?
VIP
Windows Vista Access 2010 32bit
you need another query, the main query,Q1
then Q2 to do your count of Q1
then the report uses Q2, and sorts on the count field , descending.
Advanced Beginner
Windows 10 Access 2007
Thank you!
Compute sum in main report Group footer on value from sub report
Dynamically Sort Report That Already Has Group By (Access 2003)
How to conditionally hide report group footer?
Posting Permissions
Reply With Quote