Update Query

[Ganley]

Can anyone help me.

Attempting to run an update query to strip out some information from a table.

Basically I want to remove the Tél : information & leave just the telephone number

Tél : (+41 22) 718 10 00


Any ideas.


Thanks.

 

[miguel vasquez]

I would insert a Right() formula in the Query. For instance, If you just want to see the last 9 digits(including space), I Would use it like this :
Telephone : Right([field Name], 9)

 

[Ganley]

Thanks Miguel.