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

  • Thread starter Thread starter JLPG
  • Start date Start date
J

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.
 
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.
 
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.
 
Back
Top