Coding Averages from a Query

[Steve G]

Hi,

I am trying to create a form that can project a 10, 20,
and 50 day trend average from a table/query.

I have a text box for each trend to show the data. What I
would like each one to do is pull the voulme usage amount
from the number of current past days (ie, 10 days back
from today, not 10 days starting at the beginning of the
year). I have two fields for the information to be pulled
from, date (in date/time format) and volume (in numeric
format).

How would I code each text box to give me a running trend?
I would like to find out an average usage for the past 10,
20, and 50 days. All the information is on the current
form I am forecasting the trends. Should I include this in
my query table to work properly?

Please help. Thank you.

 

[Van T. Dinh]

(answered in Queries)

Please do not multi-post. If you think it is necessary for your question to
appear in more than 1 newsgroup, use cross-posting.

 

[barcelos.pires]

(answered in Queries)

Please do not multi-post. If you think it is necessary for your question to
appear in more than 1 newsgroup, use cross-posting.