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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
You could use the built-in Replace function:

Replace([MyNameField], " & ", " and ")
 
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!
 
Back
Top