nested loop query

[Chose.cz]

Taking it back, problem solved by using ultra-simple INSERT INTO...SELECT
I'm dumb

------
Hi,

I have the following problem:

I need to loop INSERT INTO query the following way:
I have columns "WeekNumber" and "Weekday"

Now I need to pre-create rows for a whole year. It should look this way:

WeekNumber Weekday
1 1
1 2
1 3
1 4
1 5
1 6
1 7
2 1
2 2
2 3
2 4
2 5
2 6
2 7
3 1

and so on

Is there a way to do this with a query? I am a total newbie with VBA, so I don't understand and can't modify the code snippets I searched for.

Please send me to hell if this has been already discussed.

JM