Given the G&A Service Acquisition, Cash Disbursement and CashDisbforG&A Service

Given the G&A Service Acquisition, Cash Disbursement and CashDisbforG&A Service Acquisition tables below, which of the following approaches would be the most valid one to create a query for accounts payable for G&A services as of July 15, 2003?

A) Query 1: Sum the G&A Service Amount in the G&A Service Acquisition table as GAamount
Query 2: Sum the Amount in the Cash Disbursement table as CDAmount
Query 3: Calculate GAamount - Nz(CDAmount) as Accounts Payable for G&A Services
B) Query 1: In G&A Service Acquisition table, constrain G&A service acquisition date <=7/15/2003 and sum Amount as GAAmount
Query 2: Join the Cash Disbursement table to the CashDisbfor G&A Service Acquisition table on Voucher and Check; constrain cash disbursement date <=7/15/2003 and sum Amount Applied as CDAmount
Query 3: Join Query 1 and Query 2 using an outer join and calculate GAAmount - Nz(CDAmount) as AP
C) Query 1: Sum G&A Service Amount in the G&A Service Acquisition table, while constraining the date field in the G&A Service Acquisition table <=7/15/2003 as GAamount
Query 2: Sum Amount in Cash Disbursement while constraining date field in Cash Disbursement table <=7/15/2003 and constraining Vendor Number to be Not Null as CDAmount
Query 3: Calculate GAamount - Nz(CDAmount) as Accounts Payable for G&A Services
D) Query 1: In G&A Service Acquisition table, group by G&A Acq and Amount, while constraining the date field in the G&A Service Acquisition table <=7/15/2003 as GAAmount
Query 2: Join the Cash Disbursement table to the CashDisbfor G&A Service Acquisition table on Voucher and Check; constrain cash disbursement date <=7/15/2003,group by G&A Acq and sum Amount Applied as CDAmount
Query 3: Join Query 1 and Query 2 on G&A Acq; calculate GAamount - Nz(CDAmount) as ApbyAcqQuery 4: Sum Query 3's APbyAcq field
E) Query 1: Sum G&A Service Amount in the G&A Service Acquisition table, while constraining the date field in the G&A Service Acquisition table <=7/15/03 as GAamount
Query 2: Sum Amount in Cash Disbursement while constraining date field in Cash Disbursement table <=7/15/03 as CDAmount
Query 3: Calculate GAamount - Nz(CDAmount) as Accounts Payable for G&A Services