I wonder if adding in an extra set of parentheses may help to the code in my last post will help, i.e.
Code:
SELECT Accounts.ClientID, Accounts.ProductID, Accounts.MonthlyDate, Accounts.IncludeComposite, Accounts.TransferIn, Accounts.TransferOut, Accounts.Fees, Accounts.Interest, Accounts.Dividends, qryE.[Assets Add/Sub], qryF.[Assets Add/Sub], qryD.[Assets Add/Sub], qryC.[Assets Add/Sub], qryB.[Assets Add/Sub], qryA.[Assets Add/Sub], qryA.EOMAssetValue, qryB.EOMAssetValue, qryC.EOMAssetValue, qryD.EOMAssetValue, qryE.EOMAssetValue, qryF.EOMAssetValue
FROM ((((((Accounts
INNER JOIN qryA
ON (Accounts.MonthlyDate = qryA.MonthlyDate) AND (Accounts.ClientID = qryA.ClientID))
INNER JOIN qryB
ON (Accounts.MonthlyDate = qryB.MonthlyDate) AND (Accounts.ClientID = qryB.ClientID))
INNER JOIN qryC
ON (Accounts.MonthlyDate = qryC.MonthlyDate) AND (Accounts.ClientID = qryC.ClientID))
INNER JOIN qryD
ON (Accounts.MonthlyDate = qryD.MonthlyDate) AND (Accounts.ClientID = qryD.ClientID))
INNER JOIN qryE
ON (Accounts.MonthlyDate = qryE.MonthlyDate) AND (Accounts.ClientID = qryE.ClientID))
INNER JOIN qryF
ON (Accounts.MonthlyDate = qryF.MonthlyDate) AND (Accounts.ClientID = qryF.ClientID))
WHERE (((Accounts.ClientID)=1));
If you are still not getting anything to return, try to do a relationship just between the original table and qryF, i.e.
Code:
SELECT Accounts.ClientID, Accounts.ProductID, Accounts.MonthlyDate, Accounts.IncludeComposite, Accounts.TransferIn, Accounts.TransferOut, Accounts.Fees, Accounts.Interest, Accounts.Dividends, qryF.[Assets Add/Sub], qryF.EOMAssetValue
FROM Accounts
INNER JOIN qryF
ON (Accounts.MonthlyDate = qryF.MonthlyDate) AND (Accounts.ClientID = qryF.ClientID)
WHERE Accounts.ClientID=1;
Does that return the values from qryF that you expect?