回答編集履歴

推敲

2019/05/15 12:02

投稿

スコア25430

answer CHANGED Viewed

@@ -1,13 +1,13 @@
 私もttyp03さんのように記述しますが、一応別な書き方として
+ついでに日付型の修正と`into #login`を省いた。
 ```VBA
 login = "SELECT " & _
         "distinct kr_recoponloginlog2.customer_cd " & _
-        "into #login " & _
         "FROM " & _
         "dba.kr_recoponloginlog2 " & _
         "WHERE " & _
         "kr_recoponloginlog2.kigyo_cd='130' and " & _
-        "kr_recoponloginlog2.loginday BETWEEN   ' & sday & 00:00:00' " & _
+        "kr_recoponloginlog2.loginday BETWEEN #" & sday & " 00:00:00#" & _
-        "AND  ' & fday & 00:00:00'"
+        "AND  #" & fday & " 00:00:00#"
 ```