J
John
I want to take one field of data and get three averages.
I need to take a field that has 180 rows (records) and
average the data from row 1-60 and assign it to var1.
Then I need to take the average of row 61-120 (in the same
field as the above) and assign it to var2. Finally I need
the average from row 121-180 and assign it to var3. I
only know how to take the average of the whole field. One
more thing, the table that this calc will be done in will
be chosen by the user, so I need to use a variable name
for the recordset.
any help would be appreciated,
john g
I need to take a field that has 180 rows (records) and
average the data from row 1-60 and assign it to var1.
Then I need to take the average of row 61-120 (in the same
field as the above) and assign it to var2. Finally I need
the average from row 121-180 and assign it to var3. I
only know how to take the average of the whole field. One
more thing, the table that this calc will be done in will
be chosen by the user, so I need to use a variable name
for the recordset.
any help would be appreciated,
john g