回答編集履歴
1
修正
test
CHANGED
@@ -20,13 +20,9 @@
|
|
20
20
|
|
21
21
|
WHERE 完済=False and 氏名<>"削除済"
|
22
22
|
|
23
|
-
And (
|
23
|
+
And (Nz(費目1総額)+Nz(費目2総額)+・・・+Nz(費目15総額))<=費目返済済額
|
24
24
|
|
25
|
-
(Nz(費目1総額)+Nz(費目2総額)+・・・+Nz(費目15総額))>=費目返済済額
|
26
|
-
|
27
|
-
|
25
|
+
And 返済済総額=0
|
28
|
-
|
29
|
-
)
|
30
26
|
|
31
27
|
```
|
32
28
|
|