Link to home
Start Free TrialLog in
Avatar of asjahir
asjahir

asked on

Debit - Credit Calculation

I'm developing Accounts & Receivable Module. I find difficult when I calcuate the debit credit calculation, for e.g.

My report figure should be

Date          Particular     Debit     Credit     Balance
1/2/2002     Inv 292             $1200          $1200
2/2/2002     Paymnt 219          $ 500     $ 700
5/2/2002     Inv 392          $200          $ 900
6/2/2002     Inv 394          $ 50          $ 950

In above statement, how can I calculate the Balance in Access.

Before this type of question posted also in
 https://www.experts-exchange.com/questions/20338642/A-summary-query.html
ASKER CERTIFIED SOLUTION
Avatar of rrein
rrein

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Another option is to add a field to your RecordSource query.  Call this field Balance where:

Balance: [Debt]-[Credit]

and enter Balance for ControlSource property of txtBalance on your form.

If you want to have displays like ($120.00) for -$120.00, you need to revise Format property of txtBalance on your form to do this.

Regards,

Mike
Avatar of Benjamin Lu
Asjahir,

Do you want the balance result like this:

Date       Particular Debit     Credit      Balance
1/2/2002 INV 292     $1,200.00     $1,200.0 $0.00
2/2/2002 Paymnt 219  $500.00     $700.00      ($200.00)
2/5/2002 Inv 392     $200.00     $900.00      ($900.00)
2/6/2002 Inv 394     $50.00     $950.00      ($1,800.00)

Ben
asjahir,
No comment has been added lately (70 days), so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area for this question:

RECOMMENDATION: Award points to rrein http:#8311278

Please leave any comments here within 7 days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Thanks,

TextReport
EE Cleanup Volunteer
---------------------
Avatar of gold64111
gold64111

Need help please!!!!!!
i would like to build a database using access, that gives a running total every morning from the previous day debits and credits. however i would like to get the information from excel every morning. Note: i have over a 40,000 accounts, however not all 40,000 account have a transaction everyday.
my report should look  like this each morning:
My report figure should be

Account#       Date         Balance      Debit     Credit     Balance
154542121   1/2/2002     $400,000   $1200                  $398,800.00
1545454       2/2/2002     300,000                $ 700       $300,700.00
5454545       5/2/2002     1500.00    $200       $ 900     $2,200.00
54545454     6/2/2002     2000.00         0               0           noTransaction
You should post your question in a seperate topic. But why not just use Excel? If there are some things you need Access for, just link to the excel sheet from Access.
Hi SpideyMod,

How can I search for a member name (AliciaV or AlicaV).  I have the excact very simmilar solution (about sep 2003) in one of her question.  I don't have time (now) to reproduce it.

Any idea?  I couldn't find her name by sorting Answered Questions list.  

Mike