expression: where "&" appears in text field, change to "and"

M

merna

I'm a new user feeling my way through some Access 2002 basics.

I'm trying to build an expression that will do the following: Where "&"
appears in a text string, e.g. a "Name" field that might include spouse
names, change it to "and".
 
D

Douglas J. Steele

You could use the built-in Replace function:

Replace([MyNameField], " & ", " and ")
 
R

Rick B

FYI: A field should only contain one piece of data. A "name" field that
may contain multiple names is not a 'normalized' design.

A better idea would be:

FirstName
LastName
SpouseFirstNAme
SpouseLastNAme



Getting this data in a normalized design will make a big difference down the
road!
 
Top