So i need to run a query to correct the telephone numbers within two fields
Mobile
Landland
due to the many data sources sometime we have a landline within the mobile field and the mobile within landline. i need to have access do a final clean-up and move the number to the correct file. so thinking of creating a new temp table and use append query not not 100% that's the best solution anyone got any ideas
Mobile
Landland
due to the many data sources sometime we have a landline within the mobile field and the mobile within landline. i need to have access do a final clean-up and move the number to the correct file. so thinking of creating a new temp table and use append query not not 100% that's the best solution anyone got any ideas