How to figure Monthly Average

[Jan :\)]

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

 

[Jan :\)]

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

 

[jayniak]

--
jayniak

 

[Jan :\)]

Please disregard, was provided the SQL to do this off group.

Jan