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!