concateing names

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

Guest

I have a field in a query called Name:[strFName]+" "+[strLName] this works
great to put the first name and last name together in one field. however if
either strFName or strLName is null the field Name: returns empty. What I
want is to have the field Name: return a value even if one or the other is
null/empty. I hope this makes sense. Thanks inadvance for the help and Merry
Christmas

LTFass
 
LtFass said:
I have a field in a query called Name:[strFName]+" "+[strLName] this works
great to put the first name and last name together in one field. however if
either strFName or strLName is null the field Name: returns empty. What I
want is to have the field Name: return a value even if one or the other is
null/empty. I hope this makes sense. Thanks inadvance for the help and Merry
Christmas

LTFass
Click to expand...




Name:[strFName]&" "&[strLName]
 
Merry Christmas :Thanks that did the trick I quess I just didn't have enough
coffee this morning

Rick B said:
LtFass said:
I have a field in a query called Name:[strFName]+" "+[strLName] this works
great to put the first name and last name together in one field. however if
either strFName or strLName is null the field Name: returns empty. What I
want is to have the field Name: return a value even if one or the other is
null/empty. I hope this makes sense. Thanks inadvance for the help and Merry
Christmas

LTFass
Click to expand...




Name:[strFName]&" "&[strLName]
Click to expand...
 
Back
Top