If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sort by calculation (a summation field) in report
I have a summary report generated. I would like to sort based on the totals
field which is a summation ... can I do this? |
#2
|
|||
|
|||
Sort by calculation (a summation field) in report
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. -- Duane Hookom Microsoft Access MVP "Jill" wrote: I have a summary report generated. I would like to sort based on the totals field which is a summation ... can I do this? |
Thread Tools | |
Display Modes | |
|
|