I have a database that has 1000 records in it, each has a container field with an different image in it. Each record already has a unique identifying sequence number. (Auto-Enter serial number on creation).
I need to add an identifier (barcode) that changes (incrementally) after every fourth record. (i.e., records 1,2,3,and 4 will have barcode number 0001, records 5,6,7 and 8 will have barcode number 0002, records 9,10,11, and 12 will have barcode number 0003, etc.) I have barcode tools, etc., just need to create the calculation field that will produce the "value" that will be used to generate the barcode.
I am thinking this is a relatively simple calculation, but can't for the life of me figure out how to "google" my question to find an answer. ("repeating serial number"?)
Thanks for any insight!
If you use sequence number for the base,
Div ( sequence number + 3 ; 4 )
For adapt to 4 digit,
SerialIncrement ( "0000" ; Div ( sequence number + 3 ; 4 ) )