How can I sort an access report by an avg value in a footer?

[JLPG]

I would like to sort the groups in a report by the summarized data for each
group. ie, Data is grouped by a number and shows averages for the details, I
would like to sort the groups by the averages. Thanks for any help.

 

[KARL DEWEY]

Create a calculated field in your query that feeds the report to produce
group average and then in the report use the Grouping and Sorting to select
that field.

 

[KARL DEWEY]

Create a calculated field in your query that feeds the report to produce
group average and then in the report use the Grouping and Sorting to select
that field.