Return specific field values in text box

Thu, 05 Dec 2013 22:12:56 GMT

Example: If we have the field NAME which includes the values: Bob, Mary, Fred and Sue.

I want to create 4 text boxes that return each of the 4 names.

What's the easiest way to do this?

=MinString(NAME) would return Bob

=MaxString(NAME) would return Sue

But how do I get the middle 2 names, Mary and Fred in their text boxes?

Thank you.

Re: Return specific field values in text box

Thu, 05 Dec 2013 22:30:38 GMT

Just found it, never mind. I can use FieldValue to do this. I knew it was easy just couldn't find it.