Sort by calculation (a summation field) in report

J

Jill

I have a summary report generated. I would like to sort based on the totals
field which is a summation ... can I do this?
 
D

Duane Hookom

No, you can't sort by a value that can't be derived from a single record in
your report's Record Source. You might be able to create a GROUP BY query
similar to your report's record source that calculates the same value. Join
this totals query into your report's record source so you make the calculated
value available to sort by.
 
Top