Address description based on 3 fields
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.