Row duplication using column list MS Access Solution

[marco778]

I would like to use Access in order to duplicate the content of a list of values into new rows based on the content of a column.
Here is an example below:
List1	List2
A	1
B	2
C	3
D	4
E	5
F	6
G	7
Duplication
A1
A2
A3
A4
A5
A6
A7
B1
B2
B3
B4
B5
B6
B7
Etc
How can I achieve this in Access?

[ItsMe]

You can create an alias within a query. When you concatenate to fields together, you can get the result you desire. You can put syntax similar to the following in the Grid at the bottom of the window of the Query Builder. It will create a new column. Place it the row labeled "Field"

MyAlias: [TableOne].
[List1] & [Table2].
[List2]

[CJ_London]

use what is called a Cartesian query - basically 2 or more tables without a join. something like

SELECT letter & number AS Duplication
FROM List1,List2

[ItsMe]

use what is called a Cartesian query...

Yeah, it looks like that is what the OP is asking for. I did not notice the pattern. Besides, I can't seem to get my SQL to stay on the same line.