Updating a table with values from the same table...

[Menthos]

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.

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