Help with end balance storing

[Hulk]

Hello, I need help how to store end balance for every record. I have one table for incomes/expenses and second for deposit/withdraw money. How to connect the 2 tables and to calculate the remain money as end balance? The idea is to show end balance in the form for each record, when I come back to see at this record what was the balance still this moment, not the end balance at whole. I hope the idea is enough clear.

[NoellaG]

Hi,

I suppose you have a table for the customer data, so if you have in the table incomes/expenses and deposit/withdraw the customer ID, you can connect these by the customer ID.
Another idea is to register the transactions in the same table and indicate with a transaction type (IN or OUT) if the amount should be added or subtracted.

succes
NG

[Hulk]

Thanks for reply, but my major problem is about end balance running on the continued form. That's what I am trying to do now.

[orange]

What are your tables? What are the link fields for the tables?

You want the current balance for each customer/account on a Form-- is this correct?

You don't need to store anything ---- just display the current balance.

[Hulk]

I want running balance on continuing form, so for every record to see current balance at that moment. I can do it with one table, because it's going to complicated. Original idea is about these 2 tables:

____Table1________________________________________ ______Table2___
1. 12.4.2010 | income | 30 | show balance 1030___________1. 10.4.2010 | deposit | 1000
2. 15.4.2010 | income | 20 | show balance 1050___________2. 22.4.2010 | withdraw | 100
3. 20.4.2010 | expense | 15 | show balance 1035
4. 23.4.2010 | income | 25 | show balance 960 (1035+25-100)
and so on

I found this http://www.tek-tips.com/faqs.cfm?fid=5248, but I can't make it work for me. I don't know what exactly to change.
Below is the database problem.

[orange]

A few suggestions.

Layout your problem in English before getting into Access.
Identify what the tables are about. Give tables a meaningful name.
There is nothing relating these tables in your database.

Take a look at this link
http://www.about-access-databases.co...ft-access.html
Click on the Entity Relationship Diagramming title and read through this section

Here's website to get the fundamentals and much more.
http://www.about-access-databases.co...ft-access.html

Good luck.

[Hulk]

Thanks, but the finding a literature is not a problem for me, there is a tons of it. I am not going to be a professional, I just need to make that function to work in my DB. As I said if it's to complicated I can do it only with one table, let's first to make the function work!