Re: crystal formula used to group
Posted: Tue Mar 24, 2020 2:30 pm
Just one more shot - this is what I have as a text field on the report and I get the print out below.
Mid({AttendSummRpt1.EmplName}, InStrRev({AttendSummRpt1.EmplName}, " ") + 1) + ", " + Mid({AttendSummRpt1.EmplName}, 1, InStrRev({AttendSummRpt1.EmplName}, " "))
Report Generated: 03/24/2020 10:22:14 AM Page 1 of 1
Mid(James E. Johnson, InStrRev(James E. Johnson, " ") + 1) + ", " + Mid(James E. Johnson, 1, InStrRev(James E. Johnson," "))
Mid(Rick E. Woxman, InStrRev(Rick E. Woxman, " ") + 1) + ", " + Mid(Rick E. Woxman, 1, InStrRev(Rick E. Woxman, " "))
Mid(John Isaacs, InStrRev(John Isaacs, " ")
Mid({AttendSummRpt1.EmplName}, InStrRev({AttendSummRpt1.EmplName}, " ") + 1) + ", " + Mid({AttendSummRpt1.EmplName}, 1, InStrRev({AttendSummRpt1.EmplName}, " "))
Report Generated: 03/24/2020 10:22:14 AM Page 1 of 1
Mid(James E. Johnson, InStrRev(James E. Johnson, " ") + 1) + ", " + Mid(James E. Johnson, 1, InStrRev(James E. Johnson," "))
Mid(Rick E. Woxman, InStrRev(Rick E. Woxman, " ") + 1) + ", " + Mid(Rick E. Woxman, 1, InStrRev(Rick E. Woxman, " "))
Mid(John Isaacs, InStrRev(John Isaacs, " ")