Koonce Posted January 15, 2007 Posted January 15, 2007 I have a field that I want to populate only if one thing is present. but I want it to populate with the following criteria. If the child's last name is different than the parents then I want the field to be the childs first name and his last name, if it is the same then I want to use the childs first name and then the Last Name field. Now is there is no child first name that is populated then I don't need anything to happen. What I did works except when there is no child first name. It will populate with the last name anyway. The Childs First Name, and if Case (Child 1 Last If Different > 0;Child 1 & " " & Child 1 Last If Different;Child 1 & " " & Last Name ) Thanks in advance.
Fitch Posted January 15, 2007 Posted January 15, 2007 case( IsEmpty( Childs First Name ) ; "" ; not IsEmpty(Child 1 Last If Different ) ; Child 1 & " " & Child 1 Last If Different ; Child 1 & " " & Last Name )
Recommended Posts
This topic is 6583 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