Convert Text to a number and 0 instead of #error

Hello Everyone,  I'm sure this is an easy thing for all you experts, but I'm having a bit of trouble with this.   I have a linked sql table in access, whereby numbers have been stored as text for ...