A
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!
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!