回答編集履歴
1
DateValueを失念していたので、訂正
test
CHANGED
|
@@ -10,7 +10,7 @@
|
|
|
10
10
|
|
|
11
11
|
on t1.id=t2.id
|
|
12
12
|
|
|
13
|
-
and t1.keydate =
|
|
13
|
+
and t1.keydate = DateValue(t2.time)
|
|
14
14
|
|
|
15
15
|
and t1.starttime > t2.time
|
|
16
16
|
|
|
@@ -36,7 +36,7 @@
|
|
|
36
36
|
|
|
37
37
|
on t1.id=t2.id
|
|
38
38
|
|
|
39
|
-
and t1.keydate =
|
|
39
|
+
and t1.keydate = DateValue(t2.time)
|
|
40
40
|
|
|
41
41
|
and t1.starttime > t2.time
|
|
42
42
|
|