By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,969 Members | 1,735 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,969 IT Pros & Developers. It's quick & easy.

Qurey question

P: n/a
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


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Sorry that should read query.
"KinRsole" <ki******@bigfoot.com> wrote in message
news:%S************@newsfe2-gui.ntli.net...
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



Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.