Ok I created a access database a long time ago, crm type database but due to poor decision making at the time I have stored phone numbers in a text data type but the data has come from a mask edit textbox in the format of: (00) 0000 0000

So I want to convert it to a plain number field but need to workout how?

Someone please help..