Triple Posted April 21, 2010 Posted April 21, 2010 Looking for a little help on how to approach this. I have a field that automatically generates the age of a person based on their date of birth. What I'm trying to figure out is how to generate a string of text on the condition that said person is over 18 and then place the string of text into a field before their full name. The text string would consist of the parent's name (located in another field), the text "A/N/F of" and then the child's first name, middle name (if they have one) and last name. So the end result if the child is a minor would be " John Smith A/N/F of Jane D. Smith" Any help would be appreciated. Thanks
bcooney Posted April 21, 2010 Posted April 21, 2010 Create a new calc field, result text, dsp_Minor= if ( Age < 18, ParentFullName & " A/N/F of " & ChildFullName, "") where ParentFullName and ChildFullName also calcs concatenating First and Last. (at one point you say over 18, and later you say is a minor).
Triple Posted April 22, 2010 Author Posted April 22, 2010 This did the trick. Thanks so much for the help.
Recommended Posts
This topic is 5387 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