I'm sure this is possible, probably with a sub-query... I want to update a record with a value from another record in the same table.
E.G.
So the query would replace the Val_1 value for the record where Check_col="s" with the corresponding Val_1 where Check_col="M"
Cheers,
Menthos
E.G.
Code:
Name Val_1 Val_2 Check_col
Test1 0 0 s
Test1 10 20 M
Test2 0 0 s
Test2 20 25 M
So the query would replace the Val_1 value for the record where Check_col="s" with the corresponding Val_1 where Check_col="M"
Cheers,
Menthos