Order by Sums in footer of report?

[CTOROCK]

Hello, I have a report that calculates the sums of inventory: Sum([TotalInv$]) in the item field footer. I am trying to sort the report descending on these sums. I've tried at =Sum([TotalInv$]) in the sorting and grouping menu but it tells me I can run an expresion in the Order By. I don't want to create anther query to do this, is there a better way? Thanks in advance for any help



"The greatest risk, is not taking one."

 

[dhookom]

The only way you can set the sorting on an aggregate value is to calculate the aggregate in the report's record source. I would create a totals query that calculates the Sum and add the new query to the report's record source.

Why don't you want to create another query?

Duane
Hook'D on Access
MS Access MVP

 

[CTOROCK]

Thanks Duane,

I have done so, just thouht that there might be another way. I already have loads of queries for so many things. Just asked to see if anyone had any other methods during report time.

Thanks again!

"The greatest risk, is not taking one."