sort report results by a custom field

  • Thread starter Thread starter Caleb
  • Start date Start date
C

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.
 
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.
 
Back
Top