S
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.
I have three text boxes 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 the 10 days since the beginning of the year). I have
two fields for the information to be pulled from, date and
volume.
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.
I am trying to create a form that can project a 10, 20,
and 50 day trend average of natural gas usage.
I have three text boxes 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 the 10 days since the beginning of the year). I have
two fields for the information to be pulled from, date and
volume.
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.