I have created a union query of two tables that list fax numbers in a text field (notice that I don't have authority to change this field format to numeric)
The resulting query has some fax numbers formatted in 2 different ways:
(123)456-7890 and 123-456-7890
How to I change the resulting union query fax field to display all numbers as follows:
1234567890?
The resulting query has some fax numbers formatted in 2 different ways:
(123)456-7890 and 123-456-7890
How to I change the resulting union query fax field to display all numbers as follows:
1234567890?