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

Incone & Expenses Statement 0
Page sort 0
Sorting Multiple Tables 1
Task Information Dialog Box not making duration changes to task 0
How to clear areas of a locked Doc after each use-- 0
Schedule Comparison Error - mismatch duration - "The duration you entered isn't supported for this field. type a duration in the standard format" 0
Outlook Web - Sorting Calendars by Alphabetical order? 0
runtime calculations?! 0

Top