回答編集履歴

1

コード間違いを修正

2018/03/26 07:04

投稿

hatena19
hatena19

スコア33722

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