Qrew LegendTry this set of three formulas
parse out the latest entry if newest are being put first.
Most Recent Entry
Trim(Right(Part(NotLeft([append at top],1),1, "["),"]"))
Date of Most Recent Entry
ToDate(NotLeft(Left([append at top], " "),1))
Name who did the most recent entry
NotLeft(Left([append at top], "]"),11)
Thanks for your reply Mark, but none of these include all the information in one field. I would like to display the last entry to include the date and name of the person so the field can be used in a report. If QB allows for showing the last entry if it appears at the bottom, I would think there is a way to show the last entry if it appears at the top.
Qrew LegendOK, np,
This tested OK. Just replace my field on the first line with yours.
var text RemoveLeadingBracket = NotLeft([Append only at top],1);
var text MostRecent = Trim(Left($RemoveLeadingBracket,"["));
If($MostRecent<>"", "[" & $MostRecent)
Mark....this worked perfect! Thank you so much for your help.
