CODEWITHSUNDEEP
ms-accessvba
Udesha
Udesha

Reputation: 1

update previous year values with current year value in an access table field

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.

Upvotes: 0

Views: 152

Answers (1)

SiliconXu
SiliconXu

Reputation: 116

It seems you are trying to look through the table and update all data in the new column (new_commission_pct) to the commission_pct of 2016. If my understanding is correct, I think you can create a UPDATE query to do this, or use vba.

Upvotes: 0

Related Questions