AnsweredAssumed Answered

Report the range of numbers located on a particular shelf or in a box

Question asked by jdhelle on Nov 17, 2011
Latest reply on Nov 17, 2011 by philmodjunk

Title

Report the range of numbers located on a particular shelf or in a box

Post

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.  

Example:

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.

 

 

Box_Calculation.jpg

Outcomes