Reply to comment

you may be able to use Part()

Yes, there is. The Part() function sees the value of a field as a series of "parts" which are delimited by one or more characters you specify. Use Part([AppendField], -3, "[") & Part([AppendField], -2, "[") & Part([AppendField], -1, "[") to get the last three comments from a field that appends to the bottom of the field. Use positive numbers in the formula to get the most recent three entries if the append field appends to the top of the field.

Regards,

--Sybil

Reply

The content of this field is kept private and will not be shown publicly.
Type the characters you see in this picture. (verify using audio)
Type the characters you see in the picture above; if you can't read them, submit the form and a new image will be generated. Not case sensitive.

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit