I am querying a linked table and saving the results in a new table. One of the columns is mobile number. I need to remove the zero at the start of the number and insert +44. I am having no luck, any suggestions.....

Do an update query first.

Here is what I did: Created Table1 with Column Num, which is TEXT, which I am assuming you have used. Then created an Update Query1 with this SQL code:

UPDATE Table1 SET Table1.Num = "+44" & Right([Num],(Len([Num]-1)))
WHERE (((Table1.Num) Like "0*"));

This uses a regular expression to add "+44" to the beginning of the old string, minus the 1 character to the left, but only acts on records where the one character to the left is "0".

Did this help?
(Back up your table first.)


mmcdonal

Thanks alot. That workd a treat.

Thanks again.