I'm trying to update the following table:
Column1 Column2
Data1 X+2
Data2 X+1
Data3 X
X = User defined input
I would like to create an update query that will update Column2 to X where Column1 = Data3 but then automatically calculate and update the values in Column2 to X+2 and X+1 for Data1 and Data2.
How can I do this in a single Update Query? So far, I have only been able to update Column2 for Data3.
Thanks for your help....