sort report results by a custom field

[Caleb]

I have a report that takes all our customer records, add up each customers
individual total spent, then subtracts all refunds from their total. Here is
ther expression: ="$" & Sum(IIf([RefundStatus] Is Null,[Total],0))
Im trying to figure out how to sort my report in order by the total after
the refunds have been taken out, right now all i can get it to do is sort by
the totals before the refunds are removed. Any help would be appreciated.

 

[Duane Hookom]

It looks like you want to sort by an aggregated value from your report's
record source. This doesn't work. You should be able to create the value in a
totals query. Then join the totals query to the report's record source so the
total is available for the sorting and grouping.