averaging in a crosstab query

[Steve Is Me]

I use a crosstab query to monitor item usage. The query groups usage by month.
There is a field that calculates the monthly average.
Currently the number of months has to be changed manually for the appropriate number of months depending on when it is run.
This is it..Mthly: Sum([Quantity]/4)
Where 4 is the number of months. Is there a way to write this so it can be automatic based on the system clock?


Such as if run in March, it would be a 3, if in November it would be 11.
And thus eliminating the need to manually change it every time it is run?

[June7]

Try:

Sum([Quantity] / Month([Date]))

[Steve Is Me]

No sale. Tried it, get error msg does not recognize [Date] as valid field name or expression.

[June7]

Sorry for my typo:

Sum([Quantity] / Month(Date()))

[Steve Is Me]

Well, all hail June7!!! Seems to work. Will continue to evaluate.

Thanks and more thanks!!!