Count Months And Store As A Value

[Guest]

Hello. I am trying to write a simple expression in a query, basically statin
add the value in column A with the value in column B, then divide by the
number of months in the current calendar year. This last part is what is
tricking me. Does anyone out there know how to write the expression so that
it knows the value should be 11? Thanks.

 

[Guest]

I am not all that good with access queries, but this works in excel.

=(A1+B1)/MONTH(NOW())

 

[Guest]

Yes what finRazel wrote will work, with some adaptation to the access way
your expression should look something like this.

NameofField: ([yourfieldname]+[yourfieldname2])/month(now())

 

[Guest]

Thank you both very much. I will try it.

Yes what finRazel wrote will work, with some adaptation to the access way
your expression should look something like this.

NameofField: ([yourfieldname]+[yourfieldname2])/month(now())
--
Krizhek
Don''t believe anything I write. It’s all guessing anyway. Heck I even
guessed this message.

I am not all that good with access queries, but this works in excel.

=(A1+B1)/MONTH(NOW())