calculating a bank balance not working !!!

[ALI007]

I need help in trying to calculate a bank balance.
Starting balance is $2000 dollars.
My calculation is Balance = Balance + Deposit - Withdrawal.
When I add records, using that formula, it is incorrect because it keeps using the initial balance of $2000.
Please show me what is the correct formula to do this/
Thanks.

 

[paulbent]

You can only do this by having "Opening Balance" in a main bank a/c table and "Deposits" and "Withdrawals" in a joined transactions table.

Create a calc field to return the net effect of each transaction:
NetMvmnt
(Trans.Deposit = Trans.Withdrawal)

Create a summary calc field to aggregate the net values
TotTransBal
SSum(NetMvmnt) 'summary option set to "All records in Trans"

Create a calc field to return the current balance
CloseBal
BankAc.OpenBal + TotTransBal

The CloseBal field will display on a form or report based on the BankAc table.

You can also create a report view based on the Transactions table, grouped by the bank ac id, with a running summary calculation to show the running balance next to each transaction.

There's an example for inventory transactions, invcalcs.zip, in the Free Downloads section at

http://www.xpertss.com

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[ALI007]

I have two lotus approach databases joined. The main one is called Latimer. The other is joined to Latimer as HealthBase. I need to know how do you add a record to HealthBase Database with a new record being inserted in to Latimer database. Thanks in advance.

 

[paulbent]

Have to use a macro. It would store any necessary values from Latimer in variable fields, switch to a view based on HealthBase, create a new record and set the fields to the values in the variables.

You'd probably have to put a button on the Latimer form to run the macro. There isn't an event when a new record is committed to which you can attach it.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk

 

[ALI007]

I AM TRYING TO INSTALL LOTUS APPROACH 96 AND GETTING A
flw+855+overflow. what is happenig=ng

 

[paulbent]

I don't know! Approach 96 was the first 32bit version and is 8 years old now. It was bug ridden and soon replaced. I'd recommend you buy a copy of SmartSuite 9.7 or later.

Paul Bent
Northwind IT Systems

http://www.northwindit.co.uk