how to calculate sum with IF Else. urgent help!

[naks]

Hi.


I Am new here. can anyone help me out ?

I have debit & credit column. Which I use this in the report --> =IIf([PaymentMet_trans]=2,"",[Amount])
debit = 1 , credit = 2

Now, i would like to have the total sum of it. according to the debit & credit separately instead of the whole total sum.

[pbaldy]

Put a Sum around the IIf, and change the double quotes to a zero.

[naks]

i did this : =Sum(IIf([PaymentMet_trans]=2,0,[Amount]))

error pop up : this expression is typed incorrectly or is too complex etc etc ...

[pbaldy]

That looks okay; where do you have it?

[naks]

I had it at the paymentMet_trans footer

[pbaldy]

Can you post the db here?

[naks]

I have summarized the database as much. but im not sure how to upload the file.

i have tried using the manage attachments, it didn't show up.

maybe you can leave me your email

[AlexHedley]

https://www.accessforums.net/showthread.php?t=34670