Dear Arnel,
Actually, my query already contains the following SQL. How can i integrate the above with that? I have edited your SQL with correct field names and Table name.
SELECT InvoiceMaster.ID,[AdvancePayment],[GrossInv-WorksCertified-61110], [Advance 409130], (SELECT...