My users need to record a range of batch numbers for each record. Sometimes they will record multiple batch ranges for the same record. For example:

123455 thru 123472
123474 thru 123489

I need to convert the above to one field containing:
123455
123456
123457
123458
etc
123471
123472
123474
123475
etc
123488
123489

any suggestions will be greatly appreciated.

Please give us more info. Why do the users need ....? Why a range for each record?
What is a batch? Help us help you.