Recent content by nikkiwe

Got it! It was the placement of the onlastrecord statement. It needed/wanted to be placed at the beginning of the Formula - after the onfirstrecord. Here is the complete functioning forumal: hileprintingrecords; EvaluateAfter ({@Shift}); If onfirstrecord then ({@Shift}) Else IF...

Sorry it has taken me so long to get back to you. I tried as you suggested but the forumual error during the onlastrecord with "too many arguments". I have tried changing the number of brackets... no luck.... Thanks again

nope, the @shift is returning a value...

@shift interprets a time reporting code. The code determins which shift it is day, evening or night. That part is working and so is the above formual with the exception of the last records....grrr

no luck...

I know it's not correct but here is the formula. The onlastrecord part is not working. The last record is blank.. Whileprintingrecords; IF onfirstrecord then {@Shift} ELSE IF ({sheet1$.ID} = Next({sheet1$.ID})) AND ({@Shift}="DAY" AND Next({@Shift})="Evening")Then "Day" Else IF...

Thanks for the information Ian. Worked like a charm on the first record however, the last record is dependent on the previous record.... eg if an employee is coded with two shifts (day and evening) on the same day, then group the evening shift into days. I am not sure how to tell it to force...

This statement is not evaluating the first record. Any help is appreciated. Thanks! Whileprintingrecords; IF ({sheet1$.ID} = Next({sheet1$.ID})) AND ({@Shift}="DAY" AND Next({@Shift})="Evening")Then "Day" Else IF ({sheet1$.ID} = Previous({sheet1$.ID})) AND ({@Shift}="Evening" AND Previous...