Updating with complicated criteria

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Don't know if this is possible. I have a table which has vehicle values for ages 2, 3 and 4 years. Only 3 and 4 years contain data. I would like to update the 2 year value to be equal to the 3 year value plus 7 percent. So I put the update criteria to be age = 2 but how can I tell it to pull the corresponding 3 year value and increment it by 7 percent

Thanks, Pau
 
HI:

In your update query make an expression like

year2: [year3]*1.07

PaulK said:
Don't know if this is possible. I have a table which has vehicle values
Click to expand...
for ages 2, 3 and 4 years. Only 3 and 4 years contain data. I would like to
update the 2 year value to be equal to the 3 year value plus 7 percent. So I
put the update criteria to be age = 2 but how can I tell it to pull the
corresponding 3 year value and increment it by 7 percent?
 
Paul,

What is the name of the table?

What is the name of the field for 2 year old vehicles?

What is the name of the field for 3 year old vehicles?

You would/could use an update query that would take the 3 year old
value, multiply it by 1.07 and put it in the field for 2 year old vehicles.


Steve
 
Back
Top