Replace Query

Nancyade

New member
Local time
Today, 14:18
Joined
May 25, 2011
Messages
4
Below is the replace query I've writen but i need to replace more than one address,how do i go about replacing more than one address in one query?

Expr1: Replace([ Address],"12 THE SLADE PLUMSTEAD SE18 2NB"," 12 THE SLADE PLUMSTEAD LONDON SE18 2NB")
 
What do you want to replace, it looks like you only want to add a space at the start of you adressfield, why??

expr: " " & [ Address]

JR
 

Users who are viewing this thread

Back
Top Bottom