Hi all,
I have created Union query based on two tables tblValAset and VhclAprs, got stuck, how may I apply Count and sum in this union query?
-----------------------------
SELECT ReportDt, BnkNme, BnkCod, SrviceChrgs, RecdAmt, TaxDeduct
FROM tblValAset
UNION ALL
SELECT ReportDt, BnkNme, BnkCod, SrvicChrgs AS SrviceChrgs, RecdAmt, TaxDeduct
FROM tblVhclAprsl;
Thank you very much in advance..
Thanks & regards,
I have created Union query based on two tables tblValAset and VhclAprs, got stuck, how may I apply Count and sum in this union query?
-----------------------------
SELECT ReportDt, BnkNme, BnkCod, SrviceChrgs, RecdAmt, TaxDeduct
FROM tblValAset
UNION ALL
SELECT ReportDt, BnkNme, BnkCod, SrvicChrgs AS SrviceChrgs, RecdAmt, TaxDeduct
FROM tblVhclAprsl;
Thank you very much in advance..
Thanks & regards,