Hi there
I'm a complete beginner with access so please be gentle!
I need to write a qurey to calculate the daily interest earn on a saving
account.
So far I have two tables.One with the account detail and the other with the
transaction details.Account 'A' has £100 in there account on the 1st of the
month then a new transaction adds £20 to there account on the 10th and
another £50 on the 28th.I need my query to tell me the intrest on each day
of the month.So if the intrest rate is 1% then the report will show that i
get 1% of £100 for each daybetween the 1st until the 10th then 1% of £120
for the day between the 11th - 28th and 1% of £170 for the remaining days of
the month.

I think I may have made this sound more complicated than it accually is but
hope someone understands it enogh to help me out.If not please ask me to
explain the iffy bit again

Thanks in advance for any help.

cheers

Kin

Sorry that should read query.


"KinRsole" <kinrsole (AT) bigfoot (DOT) com> wrote