Formula & Evaluation time problems
Posted on 2006-05-03
Hello, we issue pre-numbered licenses that we receive from the state of Ohio. We have to account for each license, so if any are destroyed while printing, we must account for them. When we print an "audit" sheet for the licenses, we have to show any license # that was voided during printing. So for example, we issue 10 licenses at a time. The user prints them out on the license paper and the 5th one get's jammed in the printer. So they have to "void" license number 1005. On our audit sheet, we have to show that license # 1005 was destroyed in printing. The way we print out our audit sheets is that we put the voided #'s first and then the rest in consecutive order. So what should be printing out is "1005 VOID", then license #'s 1000, 1001, 1002, 1003, 1004, 1006 thru 1011. We have the report prompt for the beginning audit # and up to 5 voided audit #'s. We created an incremental formula that adds 1 to the beginning audit number and on any row that the audit number matches any of the voided audit #'s, we increment by 2, otherwise just by 1. Our problem is that everything is working except that it's printing the audit number on the report "before" it's being incremented to the next appropriate number if the prior number was voided. Because the increment needs to happen on each record that's read into the report, we can't use the "beforereadingrecords". Keeping in mind that there can be up to 5 voids per audit sheet.