回答編集履歴
1
コード間違いを修正
answer
CHANGED
|
@@ -5,6 +5,6 @@
|
|
|
5
5
|
|
|
6
6
|
For i = 1 to 124
|
|
7
7
|
CurrentDB.Execute "INSERT INTO T4 ( 会員番号, 週数, 売上 ) " & _
|
|
8
|
-
"SELECT 会員番号, " & i & " AS 週数, [" & i & "週目] AS 売上 from T3
|
|
8
|
+
"SELECT 会員番号, " & i & " AS 週数, [" & i & "週目] AS 売上 from T3;"
|
|
9
9
|
Next
|
|
10
10
|
```
|