I am trying to print missing employee numbers ...with the code below, I can only get the next sequential missing number to print ... the whole range of missing numbers doesn't print.
So if I had employee numbers 82, 95 and 99.. all I'm getting is 83 and 96...and not 83, 84, 85..etc
Your help would be greatly appreciated...thank you!!
local numbervar firstemp; // first Emp#
local numbervar nextemp; // next Emp#
local numbervar diff; // difference between firstemp and nextemp
local numbervar increase; // increment for missing Emp#'s
local numbervar result;
increase := 0;
firstemp := tonumber({PR_EMPLOYEE_MASTER_1_MC.Employee_Code});
nextemp := tonumber(next({PR_EMPLOYEE_MASTER_1_MC.Employee_Code}));
nextemp := nextemp -1;
diff := nextemp - firstemp;
if nextemp = firstemp
then ""
else (
while diff >= 1
do (
diff := diff - 1;
increase := increase + 1;
result := firstemp + increase;
exit while;
);
totext (result,"0000");
)
IP Logged
