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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum of sub-form/sub-report 10
Assigning Values to TextBoxes 1
Summary Report 2
DSum 1
Sort a calculated field 15
Summation 1
Text Field Access 2003 2
sort by sum of a field 1

Top