Custom Serial numbers
I am trying to create a field that increases in searial number EVERY 15 records are inputed, almost like a batch number. does anyone have a suggestion/calculation to make this possible?
What is significant about that group of 15 records?
You may want to set up a related table with the serial number and create a new one every 15 records. The records in your original table can be linked to records in this new table to show the "batch number" for that group.
There are numerous options for how you might automate such a process.
Retrieving data ...