Allegheny Posted November 1, 2001 Posted November 1, 2001 How can I make two fields (i.e., "first name", "last name") fill in a third field ("full name")?
LeCates Posted November 1, 2001 Posted November 1, 2001 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!
Recommended Posts
This topic is 8494 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now