I have an interesting dilemma.

I have a table with the following records:

================================================== =
Box | Series Start | Series End
========+=======================+================= =
1 | 0001 | 0025
---------------------------------------------------
2 | 0026 | 0050
---------------------------------------------------
3 | 0051 | 0075
---------------------------------------------------
4 | 0076 | 0100
---------------------------------------------------

Now, I need to create a new table that will expand each of the series in
the above table:

==========================
Box | Serial No.
========+=================
1 | 0001
--------------------------
1 | 0002
--------------------------
1 | 0003

... ... ...

--------------------------
1 | 0025
--------------------------

What comes to mind right now is creating a form with a 'while' loop. But I
would have to load the form and then press a button to run it. It would be
nice to somehow create a make table query that will do the trick.

Any ideas will be greatly appreciated!

aW.

--
Thanks a million!