Start and end number

[jenber11]

I need to take columns in table1 with start and end range and put it in a table2 with the range separated.

---

Table1

col1	col2	col3
Test1	01	03
Test2	02	03

<tbody>
</tbody>

Table2

col1	col2
test1	01
test1	02
test1	03
test2	02
test2	03

<tbody>
</tbody>

 

[alansidman]

Using the data supplied, it will require three queries to achieve what you want.

SELECT Table1.col1, Table1.col2
FROM Table1;

SELECT Table1.col1, Table1.col3
FROM Table1;

Select * from Query1
UNION ALL Select * from Query2
Order by Query1.Col1;

Once you have the third query, you run a Make Table Query to put the data into a new table.

 

[jenber11]

Thanks Alan

This is a great start but in my final table I am not getting test1 02 from table1. I am getting the first and last number but not the number between.

 

[jenber11]

In my actual database there may be 100 numbers in between the start and end number.