AnsweredAssumed Answered

Address description based on 3 fields

Question asked by MarcMcCall on Feb 11, 2012
Latest reply on Feb 13, 2012 by MarcMcCall

Title

Address description based on 3 fields

Post

Ok, so I've been working on this one for a few days with no luck.

 

I need to make an address description field based on 3 fields.  FirstName, LastName, StreetAddress1.

Not a easy as it looks, (for me anyway) I only want to use the FirstName field if it has something there, and the LastName field if it has something there, otherwise I would just use: FirstName & " " & LastName & " " & StreetAddress1.  I can't have the extra spaces if the FirstName and LastName fields are empty.

Outcomes