回答編集履歴
1
コード間違いを修正
test
CHANGED
@@ -12,7 +12,7 @@
|
|
12
12
|
|
13
13
|
CurrentDB.Execute "INSERT INTO T4 ( 会員番号, 週数, 売上 ) " & _
|
14
14
|
|
15
|
-
"SELECT 会員番号, " & i & " AS 週数, [" & i & "週目] AS 売上 from T3
|
15
|
+
"SELECT 会員番号, " & i & " AS 週数, [" & i & "週目] AS 売上 from T3;"
|
16
16
|
|
17
17
|
Next
|
18
18
|
|