Account Totals

[Ann]

My database keeps track of trades for roughly 100 accounts and for each trade
calculations are performed to give me monetary values such as NetP/L. The
trades are conducted daily and start from 2006 and continue ‘til now.

I have three different tables that I need to pull information from;
Deposits, withdrawals, and calculations (the field I need from this table is
NetPL. This table stores the results of calculations that are performed).
Each of these tables has an account number field from the “clients†table. I
need the following calculation performed for each account:

The total sum of all Deposits – the total sum of all withdrawals
Added to the Total sum of all NetP/Ls

My goal is to get a running account balance for each account. I tried to
run a query to get what I need but it’s not returning the results I expected.


Any guided help is much appreciated!

 

[KARL DEWEY]

I have three different tables that I need to pull information from;
Deposits, withdrawals, and calculations (the field I need from this table is
NetPL.
You should only have one table. Just use a field to distinguish deposits
from withdrawals. As for as the calulations they should not be stored unless
you need a 'point in time' calculation that cannot be drived later.
A query will give you the running balance by subtracting withdrawals from
deposits.