Calculate Debit and Credit

[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.

[AlexHedley]

Add a Group on the Report based on PaymentMet_trans then in the Header or Footer add the Totals.





=Sum(PaymentMet_trans)

You can find a FREE Tip at http://599cd.com/tips/access/report-sorting-grouping/


Or you could use a DSUM.
=DSUM("PaymentMet_trans", "tablename", [PaymentMet_trans]=1)
=DSUM("PaymentMet_trans", "tablename", [PaymentMet_trans]=2)
etc


Alex Hedley
TechHelp Team Leader
599CD.com

[Bob Fitz]

Cross Posting: http://www.access-programmers.co.uk/...d.php?t=246426

IMHO Cross-posting on different forums without notification is not a good idea.

Read this: http://www.excelguru.ca/content.php?...-cross-posters

[naks]

AlexHedley,

It doesn't seem to work. i have #error on the report D:

[AlexHedley]

Which one did you try?

If you tried the second one did you replace "tablename" with the name of your table

[AlexHedley]

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

[naks]

well. err sorry if i was cross-posting :x i am a newbie.

i tried the second one, changed the tablename. didnt work too

[AlexHedley]

Is [PaymentMet_trans] of type Number?

[naks]

AlexHedley, i just checked. it's short text actually. so if i change this to number, it will work ? let me have a go

[naks]

Btw, PaymentMet_trans is an option button.

IF debit is clicked. '1' will be stored inside the PaymenMet_trans, else it will be '2' if credit is clicked.

So, In my report.

I used this to actually list out the debit amount :
=IIf([PaymentMet_trans]=2,"",[Amount])

[naks]

I got it solved. I tried doing what you asked me to do. thanks

[AlexHedley]

Glad you got it working