November 1, 200124 yr How can I make two fields (i.e., "first name", "last name") fill in a third field ("full name")?
November 1, 200124 yr Unless I read your question wrong, this is a simple calculation: full name = first name & " " & last name This assumes that first name and last name are not empty. You might want to cover cases where one or both are empty. Here is one possibility: full name = Trim( If(IsEmpty(first name), "", first name & " ") & If(IsEmpty(last name), "", last name)) Good luck!
Create an account or sign in to comment