Update Query

message from nl on 27 May 2004
Using an update query, how do I update numbers like
V62.81 to V6281 (no decimal point); there are different
numbers for each record.

Nereida
 
Brian Kastel replied to nl on 27 May 2004
Left$([fld], Instr([fld], ".") - 1) & Right$([fld], Len([fld]) -
Instr([fld], "."))
 
MyndPhlyp replied to nl on 27 May 2004
UPDATE tblDummy SET tblDummy.myvalue = "V6281"
WHERE (([tblDummy]![myvalue]="V62.81"));
 

Archived message: Update Query (MS Access Database)
 
Note: To make this discussion more readable on the page the original messages have been edited to remove most of the references and quoting.