i am trying to Concatenate within a query but sometimes there is no spouse in the record; therefore I don't want the & sign to show up between FName and Spouse. This is what I have now but the & sign shows up even if the spouse filed is empty.
Shareholders: [FName] & " & " & [Spouse] & " " & [LName]
Please help
A sneaky trick is to use the fact that both the & and + operators concatenate
strings, but they handle NULL differently: "String" & NULL returns just
"String", but "String" + NULL returns NULL. Try
[FName] & (" & " + [Spouse]) & [LName]
And get ready for some complaints; my name's John Vinson, my wife is Karen
Strickler.
--
John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also
http://www.utteraccess.com