Sort by calculation (a summation field) in report

  • Thread starter Thread starter Jill
  • Start date Start date
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?
 
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.
 
Back
Top