If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to figure Monthly Average
Hi all, Access 2007, Vista Ultimate x64
I have a budget that I want to be able to calculate the monthly average amount that should be set aside for various expenses based upon the monthly amount due. I can do this on the fly but not sure how to do the necessary code for either the control on the form or the query to get that figure. Any suggestions on how to best approach this would be very much appreciated. Jan |
#2
|
|||
|
|||
How to figure Monthly Average
"Jan " wrote in message ... Hi all, Access 2007, Vista Ultimate x64 I have a budget that I want to be able to calculate the monthly average amount that should be set aside for various expenses based upon the monthly amount due. I can do this on the fly but not sure how to do the necessary code for either the control on the form or the query to get that figure. Any suggestions on how to best approach this would be very much appreciated. Jan Sorry, didn't post the collowing info for what it should be figured against: AmtDue The AmtDue for each expense per month is the basis that I would like to figure the monthly amont that should be budgeted for each expense. I realize that these amounts can change during the course of a year due to many factors, and the expected weather conditions in some cases, thus expect the monthly average can also change, but, that is also what I am hoping to see, to get a better idea of what some expenses will be during a years time. Jan |
#3
|
|||
|
|||
How to figure Monthly Average
-- jayniak "Jan " wrote: Hi all, Access 2007, Vista Ultimate x64 I have a budget that I want to be able to calculate the monthly average amount that should be set aside for various expenses based upon the monthly amount due. I can do this on the fly but not sure how to do the necessary code for either the control on the form or the query to get that figure. Any suggestions on how to best approach this would be very much appreciated. Jan |
#4
|
|||
|
|||
How to figure Monthly Average
Please disregard, was provided the SQL to do this off group.
Jan "Jan " wrote in message ... Hi all, Access 2007, Vista Ultimate x64 I have a budget that I want to be able to calculate the monthly average amount that should be set aside for various expenses based upon the monthly amount due. I can do this on the fly but not sure how to do the necessary code for either the control on the form or the query to get that figure. Any suggestions on how to best approach this would be very much appreciated. Jan |
Thread Tools | |
Display Modes | |
|
|