SELECT (select sum(nal)- sum(b_name)  from qdfCashChronology as a_name where a_name.CashID = qdfCashChronology.CashID and FORMAT(a_name.PaymentDate,'dd.mm.yyyy')<FORMAT(qdfCashChronology.PaymentDate,'dd.mm.yyyy')) AS sum_name, 
qdfCashChronology.CashID, FORMAT(PaymentDate,'dd.mm.yyyy') AS d_name, Sum(qdfCashChronology.nal) AS s_name, Sum(b_name) AS s1_name, 
(s_name-s1_name) AS p_name, IIf(sum_name is Null,0,sum_name) AS a_name, qdfCashChronology.CashTypeCalc, qdfCashChronology.BankCalc
FROM qdfCashChronology
GROUP BY qdfCashChronology.CashID, FORMAT(PaymentDate,'dd.mm.yyyy'), qdfCashChronology.CashTypeCalc, qdfCashChronology.BankCalc;