Question how to calculate rolling averages in Access

[stoynov]

Hi,<br><br>I am sorry that I am not an expert with Access - do you think you could send me an access solution? <br><br>What I am trying to get is from the table "o" with data:<br><br>A             B<br>10/31/99      1<br>11/30/99      2<br>12/31/99      3<br>1/31/00       4<br>2/28/00       5<br>3/31/00       6<br>4/30/00       7<br>5/31/00       8<br>6/30/00       9<br>7/31/00       10<br>8/31/00       11 <br>9/30/00       12<br>10/31/00      13<br><br>and I am trying to create a Query that outputs:<br><br>A             B            3monthrollingavg<br>10/31/99      1             (blank)<br>11/30/99      2             (blank)<br>12/31/99      3              2 <br>1/31/00       4              3<br>2/28/00       5              4<br>3/31/00       6              5<br>4/30/00       7              6<br>5/31/00       8              7<br>6/30/00       9              8<br>7/31/00       10             9<br>8/31/00       11             10<br>9/30/00       12             11<br>10/31/00      13             12<br><br>I would be so happy if you could let me know step by step how I can set this up. Your help would be greatly appreciated.<br><br>Thank you,<br><br>Michael