create moving averages in access report or query

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

calculating averages 4
Averaging time in 15 minute increments 3
Can't create a report from my query in Access 1
charts with data from more than one query 1
Average Calculations 2
Access 2000 School Reports Database 1
calculate average at detail level on report 6
Too Many Fields Defined Error 1

Top