I want to update all records in a tbl of a numeric field AC_NO with AC_NO preceeded by 9 for example if Account No is 8337453 it should be updated to 98337453. What will be the vba code for query