2 Queries to get a result!

[Bob Vance]

I have 2 queries qryInvoices and qrypayments
What I am trying to achieve is what was the *total* for my client 2 months
ago
ClientID is Common among both queries
-------------------------
qryPayments
SELECT tblAccountStatus.PaidAmount, tblAccountStatus.OwnerID,
tblAccountStatus.BillDate
FROM tblAccountStatus
GROUP BY tblAccountStatus.PaidAmount, tblAccountStatus.OwnerID,
tblAccountStatus.BillDate;
-----------------------------------
qryInvoices
SELECT tblInvoice.OwnerID, tblInvoice.InvoiceDate,
tblInvoice.OwnerPercentAmount
FROM tblInvoice
GROUP BY tblInvoice.OwnerID, tblInvoice.InvoiceDate,
tblInvoice.OwnerPercentAmount;