conditional calculation

[rdawadiuk]

hi, i am beginner in access , Just created simple database and trying to figure out correct way to calculate. please help
name Amount Action
a 1 Deposit
b 2 withdraw
c 3 transfer
d 4 deposit
e 5 Transfer
f 6 withdraw

Total =Sum ((IIf[Action]="Deposit", [Amount], 0))

Here I wanted above formula to give me (a + d) instead the formula gives
(a+d)- (b+e)

[rdawadiuk]

My reports looks like below, and calculation is in report footer

name....Amount....Action
a......... 1.............. Deposit
b......... 2 .............withdraw
c......... 3.............. transfer
d........ 4.............. deposit
e ........5............. Transfer
f ........6...............withdraw

thanks

[MMcCarthy]

hi, i am beginner in access , Just created simple database and trying to figure out correct way to calculate. please help
name Amount Action
a 1 Deposit
b 2 withdraw
c 3 transfer
d 4 deposit
e 5 Transfer
f 6 withdraw

Total =Sum ((IIf[Action]="Deposit", [Amount], 0))

Here I wanted above formula to give me (a + d) instead the formula gives
(a+d)- (b+e)

Formula should be ...

=Sum(IIf([Action]="Deposit", [Amount], 0))

[NeoPa]

I would have said :

=Sum(IIf([Action]="Deposit", [Amount], -[Amount]))