Fill Form then Query that Averages input

A

accessquestion

form1 has a two drop downs: (1) for retail STORE number and (2) for
accounting PERIOD.
form1 has blanks for several fields of numeric data.
form1 has a NEW button that runs a macro that uses GOTORECORD, NEW.
I have a query that averages that data, ordered by STORE, for the past year.

I NEED the averaged data (each individual field is seperately averaged) to
appear next to the entered data based on STORE and PERIOD entered at the
start of the process, ~after~ the data has been entered (but not including
it!) but ~before~ the form presents blanks for new data (a CALC button would
be nice)

Thanks!
 
Top