evaluate records then update - Please read again didn't explain well
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
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
Last edited:
