434,709 Members | 2,211 Online
Need help? Post your question and get tips & solutions from a community of 434,709 IT Pros & Developers. It's quick & easy.

# Expanding a Series

 P: n/a 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! Nov 13 '05 #1
4 Replies

 P: n/a Just a stab.... but how about a cartesean result instead of a new table. You would have a table with all the values as individual records (1....100) Then make a query with this table and the table (or query ) with the series data. Don't make any join betwen them...... You will then get a record for each possibility. Limit this for each Box....by using Between [Series Start] and [Series End] ????? Mal. "aW" wrote in message news:40********@127.0.0.1... 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! Nov 13 '05 #2

 P: n/a Mal Reeve wrote: Just a stab.... but how about a cartesean result instead of a new table. You would have a table with all the values as individual records (1....100) Then make a query with this table and the table (or query ) with the series data. Don't make any join betwen them...... You will then get a record for each possibility. Limit this for each Box....by using Between [Series Start] and [Series End] ????? Mal. "aW" wrote in message news:40********@127.0.0.1... I have an interesting dilemma. Thank you for your response, I'll play with this for a while. -- Thanks a million! Nov 13 '05 #3