G Guest Oct 31, 2006 #1 Need help to find the occurance of 'a' and 'b' in a field (ex 10a and 345b) and remove.
B Brendan Reynolds Oct 31, 2006 #2 An update query similar to the following will do it ... UPDATE tblTest SET tblTest.TestText = Replace(Replace([TestText],"a",""),"b",""); Here's a link to the on-line help topic for the Replace function ... http://office.microsoft.com/search/redir.aspx?AssetID=XT011352551033&CTT
An update query similar to the following will do it ... UPDATE tblTest SET tblTest.TestText = Replace(Replace([TestText],"a",""),"b",""); Here's a link to the on-line help topic for the Replace function ... http://office.microsoft.com/search/redir.aspx?AssetID=XT011352551033&CTT
R RoyVidar Oct 31, 2006 #4 doug s said: Need help to find the occurance of 'a' and 'b' in a field (ex 10a and 345b) and remove. Click to expand... If the letters are always at the end, you can probably use the Val function on the field in an update query. UPDATE mytable SET myfield = Val(myfield)
doug s said: Need help to find the occurance of 'a' and 'b' in a field (ex 10a and 345b) and remove. Click to expand... If the letters are always at the end, you can probably use the Val function on the field in an update query. UPDATE mytable SET myfield = Val(myfield)
