Database Design Question

I have a problem in Access2000 in retrieving the following; I am trying to get access to give me a total for the field [ContractTotal] in the [PaymentReceivedTable] as well as the fields stated in the below clause. In the [InsertDetailsTable] there is seperate entries for each item that is from the same contract. If customer purchased 10 items it wants to give me that customers total on the contract multiplied by ten. The distinct fields are [CustomerID] and [InsertNum] the problem is that those fields are ONLY distinct in every table BUT the [InsertContractDetailsTable]. Argg....slowly going crazy here!! Can anyone help?

SELECT  AccessMainTable.RepLastName, AccessMainTable.OnlineCharges, AccessMainTable.OnlineAdSold, AccessMainTable.OnlineProduction, PaymentReceivedTable.BalanceOwing, PaymentReceivedTable.BalancePaid, PaymentReceivedTable.AllPaymentsCleared, PaymentReceivedTable.CreditRate, AccessMainTable.MasterDirectory, AccessMainTable.Issue, InsertContractDetailTable.InsertNum, InsertContractDetailTable.Issue, InsertContractDetailTable.Directory, AccessMainTable.BusinessListingName, AccessMainTable.MasterInsertNum, InsertContractDetailTable.OnlineAdSizeID, InsertContractDetailTable.OnlineCategory, InsertContractDetailTable.AdSizeDescription, InsertContractDetailTable.CategoryId FROM (SELECT DISTINCT PaymentReceivedTable.InsertNum, Sum(PaymentReceivedTable.ContractTotal) AS SumPrice
FROM PaymentReceivedTable) as abc, (AccessMainTable INNER JOIN InsertContractDetailTable ON (AccessMainTable.InsertNum = InsertContractDetailTable.InsertNum) AND (AccessMainTable.CustomerId = InsertContractDetailTable.CustomerId)) INNER JOIN PaymentReceivedTable ON (AccessMainTable.InsertNum = PaymentReceivedTable.InsertNum) AND (AccessMainTable.CustomerId = PaymentReceivedTable.CustomerId)
WHERE (((AccessMainTable.MasterDirectory)=[What Directory?]) AND ((AccessMainTable.Issue)=[What Issue?]) AND ((AccessMainTable.CustomerId)=[PaymentReceivedTable].[CustomerID]) AND ((AccessMainTable.InsertNum)=[PaymentReceivedTable].[InsertNum]) AND ((InsertContractDetailTable.CustomerId)=[AccessMainTable].[CustomerID]))
GROUP BY AccessMainTable.RepLastName, AccessMainTable.OnlineCharges, AccessMainTable.OnlineAdSold, AccessMainTable.OnlineProduction, PaymentReceivedTable.BalanceOwing, PaymentReceivedTable.BalancePaid, PaymentReceivedTable.AllPaymentsCleared, PaymentReceivedTable.CreditRate, AccessMainTable.MasterDirectory, AccessMainTable.Issue, InsertContractDetailTable.InsertNum, InsertContractDetailTable.Issue, InsertContractDetailTable.Directory, AccessMainTable.BusinessListingName, AccessMainTable.MasterInsertNum, InsertContractDetailTable.OnlineAdSizeID, InsertContractDetailTable.OnlineCategory, InsertContractDetailTable.AdSizeDescription, InsertContractDetailTable.CategoryId, PaymentReceivedTable.CustomerId, PaymentReceivedTable.ContractTotal, PaymentReceivedTable.InsertNum;

Thanks in advance,

Vera Palmeri