var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Insert into query help
First of all i apologise if i have posted this in an incorrect board.
I have successfully created a query to update cells in a table but i cannot figure out how to update cells within a table that match the contents of another cell.
What i want to do is find all "NEW 5 AMP FUSE" in [Test Type] cell that have a null value in [Value] and change it to "0.1" and the cell [Unit] to "£" if that makes any sense.
UPDATE [Asset Test Records] SET [Test Type]=REPLACE([Test Type],'95','NEW 5 AMP FUSE');
Any help greatly appreciated
You should have the condition (Test Type equal to your string) in a where clause, and assign the new value as part of the SET clause.