Hi,

I have a problem that a simple update string should fix though i am not familiar with the syntax. I have fields full of phone numbers that i need to do two things to:

1. remove the first digit of the area code

2. add an international calling code

So a number like "02-8765-7464" needs to become "0011-61-2-8765-7464".

At first i tried an update string that updated the code by counting from the right, but some numbers have different amount of digits! So please if you can suggest a way from the left to remove the first digit and add in "0011-61-" id appreciate :)

Thanks,

M.

You would update this using:

Right([PhoneNumber], Len([PhoneNumber]) - 1)

Then update it again using a seperate query and:

"0011-61-" & [PhoneNumber]

Did that help?

mmcdonal

Thank you very much. The update of the additional characters was logical, i just hadnt to date learnt how to specify the -1... i was counting from the end which came unstuck when a number of differing length to my absolute query popped up :P

Thanks again! Im seeing how forums might fill the gaps between hardcopy documentation (in moderation! :P).