Remove Fields In an Address Label

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

Guest

If Have a text box with names and addresses, I would like to remove the
Wifes surname where the Husbands Surname = Wifes Surname

[HusbandFirstName] &" and " & [WifeFirstName]
[HusbandsSurname] & Trim((" "+[WifesSurname]) IIF [HusbandsSurname]=
[WifesSurname])

I realize thats probably a real mess but hopefully it will give you an idea
of what I'm trying to do

Thanks Sean
 
Sean, is this what you mean:

IIf([Husbands Surname] = [Wifes Surname], _
[HusbandFirstName] & " and " & [WifeFirstName] & _
" " & [Husbands Surname], _
[HusbandFirstName] &" " & [Husbands Surname] & _
" / " & [WifeFirstName] & " " & [WifesSurname])

Would output
Bill and Mary Smith
Bill Smith / Mary Jones

Ron W
www.WorksRite.com
 
Back
Top