Open Recordset, Evaluate data, then update

[JWMAYO]

PLEASE HELPOpen Recordset, Evaluate data, then update

I needs to open a recordset, evaluate sales information(demonstrated by records 1-3 below) in about 10 records by determing growth percentages from record to record... then update a sales plan with the latest sales year plus the average growth.. For example
xxxxxxxxxxxxxxxxxxxxxxxxxxx 2004 -----2005---------2006
Record 1 Product 1 ---------$1000
Record 2 Product 2 -------------------$1500
Record 3 Product 3 ---------------------------------$2250

Need to update the below RECORD
Record 4 Product 4 average 50% so 2250+50%= 3375 ETC,.,,,,

NOW I MAY NEED TO EVALUATE 50 OR MORE RECORDS BEFORE DO THE ABOVE CALCULATION... aNY HELP WITH THIS WOULD BE GREAT.
THX

 

[KenHigg]

Seems you could do this with a totals query - ?

 

[JWMAYO]

Ken
Well, the problem is each record is a unique product and I need to evaluate the growth/decline rates between each title... get an average and then apply to the new title coming out in 09... But please explain
if you think that will cover this.