access 2003 - remove spaces in field.
Posted on 2007-08-07
I have an Access Table with spaces in the Telephoen field and want to remove them.
I am a complete access beginner so I need everything explained if you have the time..
From previous posts in EE I thought I have to do this:
Create a Query -- and go into the query editor.
Then choose the table...
From here choose the Field ---- Telephone, then select the table from the drop down box...
Then in the criteria?? put the statement:
"Update Data set Telephone"=Replace([Telephone]," ","")
And hit run ( the ! ) but I get data type mismatch in criteria expresssion...
PLease help me sort this out...