>FOR ii = 1 TO 3 > SELECT attempts > GO TOP > DO WHILE !EOF() > person = evaluate("attempts.personnel" + ALLT(STR(ii))) &&value of the field wait window vartype(Person) && What's the type of this person: is it male/female, oops, I mean, is it Numeric, Logic or Char > IF !EMPTY(Person) && Value of the field if vartype(Person)="C" && Char > rtrimpers = RTRIM(person) > PersID=RIGHTC(rtrimpers,12) > IF RIGHTC(PersID,6) = "ACTIVE" > PersID=LEFTC(person,5) > ELSE > PersID=RIGHTC(rtrimpers,5) > ENDIF endif && End of vartype check >* ENDIF > IF IsNull(PersID) > PersID = "" > ENDIF > IF PersID=&OMDID1 > IF ATTEMPTS.ROUTE="ORAL" store &O_ATT+ATTEMPTS.ATTS1 to ("O_ATT"+transform(LI)) && Name expression, are you sure, the first macro is needed? store &T_ATT+ATTEMPTS.ATTS1 to ("T_ATT"+transform(LI)) && Name expression > >