Running Balances

[Jx4]

I have a table with the account balance, a table with the account holders infomation, a table with the interest rate, and a table with the transactions.

Then I start the queries to get some amounts that I need.
I have a query that tells you the transactions done in the first month.
A query that sorts them with all the accounts.
A query that adds interest on the transactions.
A query that adds interest on the balance.
A query that take the balance of the previous month, add the interest to it, take away the transactions and the transaction interest.

Then the next month query starts the whole process over again using the balance from the previous month as a starting point.

Everything works as it goes through the different months, it will calculate the interest in June but it says that it runs out of system resources when it tries to calculate a balance for June.

I'm not sure if you have any suggestions for the database, but I would apreciate any you can think of.

Thanks

[Rabbit]

System Resources Exceeded

[NeoPa]

You've posted this same basic questions three times now.
Do you really imagine that this will garner anything more than irritation on the part of those trying to help.
Answers have been posted which you've simply ignored, not having even the courtesy to reply.

We can't guarantee answers to all your questions. I'm confident that between us we will give what help we can. If no-one knows the definitive answer to your question then I'm sorry but that's just how it is sometimes.

Maybe someone could work with you to progress the situation, except you've never replied to any answers yet.

MODERATOR.

PS. For the record, the other one is Too many queries?

[Jx4]

I am sorry that you feel so strongly about me trying to clarify my question. My first question went unanswered for awhile and I thought maybe I didn't explain myself well enough so I thought I would try again. I am fairly new at access and posting so I didn't mean to make you so annoyed! As I worked on my database and figured things out I thought I should be more specific in my questions. I will try to delete my posts as not bother anyone! I was trying to get some help!

You've posted this same basic questions three times now.
Do you really imagine that this will garner anything more than irritation on the part of those trying to help.
Answers have been posted which you've simply ignored, not having even the courtesy to reply.

We can't guarantee answers to all your questions. I'm confident that between us we will give what help we can. If no-one knows the definitive answer to your question then I'm sorry but that's just how it is sometimes.

Maybe someone could work with you to progress the situation, except you've never replied to any answers yet.

MODERATOR.

PS. For the record, the other one is Too many queries?

[NeoPa]

I am sorry that you feel so strongly about me trying to clarify my question. My first question went unanswered for awhile and I thought maybe I didn't explain myself well enough so I thought I would try again. I am fairly new at access and posting so I didn't mean to make you so annoyed! As I worked on my database and figured things out I thought I should be more specific in my questions. I will try to delete my posts as not bother anyone! I was trying to get some help!

Please don't feel offended.
I didn't mean to sound heavy. Just trying to tidy up the confusion to make it easier for our (voluntary) experts to be able to help more easily.
The thing to do in your case is :

• Always to reply to posted answers to your thread. If they are not very helpful sometimes, they're invariably someone's attempt to help.
• When you have updates (or clarifications) to your original question, post them in the same thread, simply as different posts. That way it is easier to work on your problem.

Above all, I am not annoyed (especially as you've explained why...) but as a moderator it is my responsibility to try to keep things in here running as smoothly as possible. If you saw the volume of questions we deal with on a daily basis you'd better understand why that has to be treated seriously.