, , , , , , , . :
(1 );
, (2 );
, , :
<=
. , ( ) , .
.
:
SQL :
SELECT ., .[ ], Sum([]*[]*(1+[]-[])) AS
FROM INNER JOIN ( INNER JOIN ON .[ ] = .[ ]) ON .[ ] = .[ ]
GROUP BY ., .[ ];
:
SQL :
SELECT .[ ], Sum(.[ ]) AS [Sum- ]
FROM
GROUP BY .[ ];
, 6 7 . .
, , :
: [ ]![] - Nz([ ]![Sum- ])
Nz , Null Sum- 0, Access Null . .
. , , . . SQL :
SELECT [ ]., [ ].[ ], [ ]., [ ].[Sum- ], [ ]!-Nz([ ]![Sum- ]) AS
FROM [ ] LEFT JOIN [ ] ON [ ].[ ] = [ ].[ ];
|
|
. QBE SQL .