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!