Calculate a Moving Average in Microsoft Access (Rolling Average, Rolling Mean, Moving Mean)

In this video, I will show you how to calculate a standard moving average (also called a rolling average, moving mean, or rolling mean) in Microsoft Access.

Windle from Williamsburg, Virginia (a Platinum Member) asks: can you show me how to do a moving average in Access?

Silver Members and up get access to an Extended Cut of this video. Members will see how to calculate the average over the last five periods instead of just the last five days. This is necessary if you have gaps in your dates (missing data on the weekends, for example).

MEMBERS VIDEO:

BECOME A MEMBER:

LEARN MORE:

LINKS:

COURSES:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, moving average, moving mean, rolling average, rolling mean, simple moving average, dlookup, davg

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[PatrickKalush]

Fought with this a whole day to get the syntax correct for the criteria in DAvg. Still had to try several times with yours, but this was the one. Thank you.

[gregoryjeffery]

How would I modify this if I needed to have a constant running average for a small (~75) record database? I've tried several different configurations but either end in error or in just getting the 1 number from that row.