Interest calculations

[Patrick]

I am trying to calculate interest payments on balances of deposits into an account on a monthly basis such as a bank would show on your statement every month. can someone give me an example in access. I am trying to create a system for an investment company ie a company that hodls money for others and give them interest at the end of each month. during the month there are deposits and withdrawals held in a transaction file

 

[Guest]

You'll need to give more information before anyone can
help. Eg. is the interest calculated on daily or monthly
on a minimum balance; does the amount of interest change
with the appropriate balance.

Rod Scoullar.