Moving average calculation

[Secue]

Hi:



Is there any formual or any way to calculate moving average on access? What I need is to calculate a value based on data from the past 3 months:

I have follwing structure for example:

Column A ----- Column B -------- Column C
ValueA1 ------- Value B1 ---------
ValueA2 ------- Value B2 ---------
ValueA3 ------- Value B3 --------- =average (ValueB1, valueB2, valueB3)
ValueA4 ------- Value B4 --------- = average (valueB2, valueB3, valueB4)


My main point id how to calculate values for column C.

Thank you.

[orange]

I found this link via Google search
http://support.microsoft.com/kb/143237