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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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
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
---------------------
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
---------------------
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
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
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
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