Script to insert incremental values in subsequent records
I need some help with what seems to be a very simple task. I have an established database which includes newly inserted storage info fields, box # and box position #. The box # field will contain 1 for the first 100 records, 2 for the 2nd 100 records, 3 for the third 100 records, and so on. The box position field on the other hand will need to contain values 1-100 for the 100 records, 1-100 for the second 100 records, and so on to denote what position each item (represented by the record) is in each box which has 100 positions within it. Is there anyone out there who can help me with this? Thanks in advance!!