title: Calculate Moving Average - MS ACCESS
body: <p>I would like to calculate the moving average of 4 rows. I have searched online and tried different methods but I have not got the result. This is an example of my table</p>
  
  <pre><code>    Week    DATES       CURRYR            MOVINGAVG
         1    4/7/2017    351,929.76  
         2    4/14/2017   352,202.99  
         3    4/21/2017   483,987.60  
         4    4/28/2017   358,125.55  (AVG CURRYR 0F #1-#4)
         5    5/5/2017    335,180.47  (AVG CURRYR 0F #2-#5)
         6    5/12/2017   421,693.56  (AVG CURRYR 0F #3-#6)
         7    5/19/2017   394,410.34  (AVG CURRYR 0F #4-#7)
         8    5/26/2017   437,064.82  (AVG CURRYR 0F #5-#8)
         9    6/2/2017    536,921.87  (AVG CURRYR 0F #6-#9)
        10    6/9/2017    358,177.15  (AVG CURRYR 0F #7-#10)
        11    6/16/2017   418,651.36  (AVG CURRYR 0F #8-#11)
        12    6/23/2017   402,590.79  (AVG CURRYR 0F #9-#12)
        13    6/30/2017   407,775.24  (AVG CURRYR 0F #10-#13)
        14    7/7/2017    391,020.15  (AVG CURRYR 0F #11-#14)
  </code></pre>
  
  <p>And so no.... </p>
  
  <p>Is there a way I could execute this in MS ACCESS</p>