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
+ 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
1 Reply

 P: n/a Sorry that should read query. "KinRsole" 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.