Khurramshaikh47
Member
- Local time
- Tomorrow, 03:42
- Joined
- Aug 19, 2021
- Messages
- 212
When I am trying to save the following SQL Query an error is appearing please check the screenshot.
SELECT bDebitVoucher.VoucherID,
bDebitVoucher.PaymentDate,
bDebitVoucher.AmountReceived,
bDebitVoucher.AmountPaid,
(Select Sum([AmountReceived]-[AmountPaid])From DebitVoucher WHERE
DebitVoucher.<=bDebitVoucher.Date) As Balance FROM
DebitVoucher As bDebitVoucher ORDER BY bDebitVoucher.Date;
Please help me to correct the statement.
Thank you
SELECT bDebitVoucher.VoucherID,
bDebitVoucher.PaymentDate,
bDebitVoucher.AmountReceived,
bDebitVoucher.AmountPaid,
(Select Sum([AmountReceived]-[AmountPaid])From DebitVoucher WHERE
DebitVoucher.<=bDebitVoucher.Date) As Balance FROM
DebitVoucher As bDebitVoucher ORDER BY bDebitVoucher.Date;
Please help me to correct the statement.
Thank you