回答編集履歴
1
推敲
test
CHANGED
|
@@ -1,12 +1,12 @@
|
|
|
1
1
|
私もttyp03さんのように記述しますが、一応別な書き方として
|
|
2
|
+
|
|
3
|
+
ついでに日付型の修正と`into #login`を省いた。
|
|
2
4
|
|
|
3
5
|
```VBA
|
|
4
6
|
|
|
5
7
|
login = "SELECT " & _
|
|
6
8
|
|
|
7
9
|
"distinct kr_recoponloginlog2.customer_cd " & _
|
|
8
|
-
|
|
9
|
-
"into #login " & _
|
|
10
10
|
|
|
11
11
|
"FROM " & _
|
|
12
12
|
|
|
@@ -16,9 +16,9 @@
|
|
|
16
16
|
|
|
17
17
|
"kr_recoponloginlog2.kigyo_cd='130' and " & _
|
|
18
18
|
|
|
19
|
-
"kr_recoponloginlog2.loginday BETWEEN
|
|
19
|
+
"kr_recoponloginlog2.loginday BETWEEN #" & sday & " 00:00:00#" & _
|
|
20
20
|
|
|
21
|
-
"AND
|
|
21
|
+
"AND #" & fday & " 00:00:00#"
|
|
22
22
|
|
|
23
23
|
|
|
24
24
|
|