IIF, THEN SUM

  • Thread starter Thread starter JOCATS1
  • Start date Start date
J

JOCATS1

Is there a way to do an if then sum in a report
What I want is somthing that will pul
If [Future_int] is <11 and >5 then sum [current_balance
Where the current_balance ends up being the total for all account
between 6 and 10. Any ideas would be helpful
 
JOCATS1 said:
Is there a way to do an if then sum in a report?
What I want is somthing that will pull
If [Future_int] is <11 and >5 then sum [current_balance]
Where the current_balance ends up being the total for all accounts
between 6 and 10. Any ideas would be helpful.
Click to expand...

You don't need an IIF, just do this

=DSum("[Balance]","YourTableName","[Future_int]>5 and [Future_int]<11")

of course you replace Balance with the name of the field you want to sum and
YourTableName with the name of the table that contains it and Future_int.

Tom Lake
 
Back
Top