sort summary

[Guest]

In an access report: The reports is grouped by sales person. I have sales
volume that is summed in the footer. I'm having a hard time seeing how I can
sort by the sum in the footer.

 

[Guest]

If you want to sort on a field that is calculated, you need to do the
calculation in underlying query and create a group in the report (without a
header/footer) and sort on that field.

Barry

 

[Guest]

But I can't do an aggregrate summary in a query?

If you want to sort on a field that is calculated, you need to do the
calculation in underlying query and create a group in the report (without a
header/footer) and sort on that field.

Barry

 

[Guest]

In your query, group by salesperson and sum the volume. In the report, create
two sections: one for salesperson and one for sales volumn. Have the sales
person group display a footer and the sales volume not display a header or
footer. The order you put the groups in the grouping/sorting dialog will
determine how the report is sorted, so put the sales volume group first.

Barry