2 Queries to get a result!

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;

--
Thanks in advance for any help with this......Bob
MS Access 2007 accdb
Windows XP Home Edition Ver 5.1 Service Pack 3