O
Old Bethel
I am new to Access and am working with a preexisting database that I did not
create, so please bear wiith me. I trying to create a query that combines
individual fields to create a mailing list where the names of married couples
appears as Mr. & Mrs. Joe Smith. I'm using the following expression (I think
that is the term) that I copied from an existing query:
fullname: [Title] & " & " & [spouseTitle] & " " & [FirstName] & " " & [mi] &
" " & [LastName] & " " & [Suffix]
The problem is that some of the names have to be manually entered into a
separate table because they don't fit the standard. ie. Rev. Joe and Dr.
Jane Smith. How can I have a query disregard the "fullname" string (above)
if that record is in the table of unusual "fullnames" ? Both tables have a
common field named Household ID.
Thanks in advance for your help.
create, so please bear wiith me. I trying to create a query that combines
individual fields to create a mailing list where the names of married couples
appears as Mr. & Mrs. Joe Smith. I'm using the following expression (I think
that is the term) that I copied from an existing query:
fullname: [Title] & " & " & [spouseTitle] & " " & [FirstName] & " " & [mi] &
" " & [LastName] & " " & [Suffix]
The problem is that some of the names have to be manually entered into a
separate table because they don't fit the standard. ie. Rev. Joe and Dr.
Jane Smith. How can I have a query disregard the "fullname" string (above)
if that record is in the table of unusual "fullnames" ? Both tables have a
common field named Household ID.
Thanks in advance for your help.