Count Months And Store As A Value

M

Mr. Smiley

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.
 
F

FinRazel

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

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

Krizhek

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())
 
M

Mr. Smiley

Thank you both very much. I will try it.

Krizhek said:
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.


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

=(A1+B1)/MONTH(NOW())
Click to expand...
Click to expand...
 
Top