title: update previous year values with current year value in an access table field
body: <p>I have a sales reps table in my access 2016 database which has sales_rep_num (around 100 numbers)column, year column(years from 2009 to 2016) and a commission_pct vary from values between 0% to 100%. I need to create a separate column in which all the previous year values will be replaced by commission_pct of 2016. for an example from 2009 to 2015 different percentage values will be replaced by a one value of 2016. I need this for an marginal calculation. If anybody can help me with this it will be a great help.  </p>