Coding for 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 of natural gas usage from a
query.

I have a text box for each trend. 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 from the beginning of the year). I have
two fields for the information to be pulled from, date (in
date/time format) and volume (in numberic format).

How would I code each text box to give me a running trend
for this query?

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 in advance.

 

[Van T. Dinh]

Check Access Help on the DAvg() Function.