G Guest Nov 25, 2004 #1 Is it possible to create a field of moving averages from an existing field in a report ? Can it be done in a query?
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 Nov 26, 2004 #2 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?
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?
