Report the range of numbers located on a particular shelf or in a box
I have a database of Diamond Disc Records that calculates where the physical record is located, Shelf # or Box #, based upon how many records fit onto one shelf and in one box by coupling number. I have several that have been entered into the database but are waiting to be cleaned and filed. I need a report that shows the range of coupling numbers on each shelf and each box to make it easier to file the remaining records. Between shelves and boxes there are more than 40 possibilities.
Shelf 1 - 50052 - 51125
Shelf 2 - 51126 - 51220
Box 1 - 80032 - 80090
Box 2 - 80091 - 80125
I have attached the scripts I use for the calculations. In the record detail display if the box # is less than 11 the word 'Shelf' displays with the number. If the box # > 11 the word 'Box' displays with the number.