#Error in output query

[Mariyka1]

Hello,
I have this formula in access - that converts different formatted phone numbers into a numeric field - because some fields are blank it give me an #Error message. I tried to run the query and append it separately to a table (with a right join) - excluding Nulls, etc. But I cant seem to get rid of the #Error . and I dont want to completely exclude the records that dont have phone numbers I just need them to show up as Null fields


Any insight is appreciated!!

Heres the formula that I use:
Replace(Replace(Replace(Replace([Data-Opportunities TS-BB-2].[Phone],')',''),'(',''),'-',''),' ','')

 

[Joe4]

Have you tried using the Nz function?
Maybe something like:

[COLOR=#333333]Replace(Replace(Replace(Replace(Nz([Data-Opportunities TS-BB-2].[Phone],""),')',''),'(',''),'-',''),' ','')[/COLOR]