create moving averages in access report or query

T

thebeej128

Is it possible to create a field of moving averages from an existing field in
a report ? Can it be done in a query?
 
T

Tom Wickerath

Try working through this KB example:

ACC2000: How to Compute Moving Averages in Visual Basic for Applications
http://support.microsoft.com/?id=210138

Then see if you can apply the same ideas to your situation.

Note: Although the title includes "ACC2000", this example should work equally well in Access 97,
2002 or 2003.

Tom
_________________________________


Is it possible to create a field of moving averages from an existing field in
a report ? Can it be done in a query?
 
Top