Please Help on Acces Querries

[yahia]

Hello Everyone
I am new her . I have a mdb that contains many tables like:

Customers. that includes the fields: CusID, CusName ...
Invoice.that includes the fields: InvoiceNo, CusID, Amount...
Incomingmoney:that includes the fields: IncomID, CusID, IncomingAmount...
Shippedcontianers that includes the fields: ShipId, CusID, ShipFeeAmount...


All these tables are linked by a field called CusID
i wanna to make a query that additionate the amounts of invoices(Amount) + shippedcontainers (ShipFeeAmount) moins - incomingmoney(IncomingAmount). this result is the balance of the customer
but when i did it by making a simple queries that includes this fields from these tables, every customers has to have a recod in every tables to be shown in the BALANCE query
in other word if a customer has somes invoices but he has no record in the table Shippedcontianers or nver make TT that allow him to have a record in Incomingmoney the query did not make a balance for him
I wanna to find i way to calculate the balance of every customers even if he has not record in every tables
I hope that i got understood
Please help me i am in need

 

[jackd]

Hello Everyone
I am new her . I have a mdb that contains many tables like:

Customers. that includes the fields: CusID, CusName ...
Invoice.that includes the fields: InvoiceNo, CusID, Amount...
Incomingmoney:that includes the fields: IncomID, CusID, IncomingAmount...
Shippedcontianers that includes the fields: ShipId, CusID, ShipFeeAmount...


All these tables are linked by a field called CusID
i wanna to make a query that additionate the amounts of invoices(Amount) + shippedcontainers (ShipFeeAmount) moins - incomingmoney(IncomingAmount). this result is the balance of the customer
but when i did it by making a simple queries that includes this fields from these tables, every customers has to have a recod in every tables to be shown in the BALANCE query
in other word if a customer has somes invoices but he has no record in the table Shippedcontianers or nver make TT that allow him to have a record in Incomingmoney the query did not make a balance for him
I wanna to find i way to calculate the balance of every customers even if he has not record in every tables
I hope that i got understood
Please help me i am in need

Please post your query sql.

 

[yahia]

thank u for ur reply
my query has the following

SELECT Customers.CusID, Customers.Name, Sum(Incomingmoney.IncomingAmount) AS IncomingAmountOfSum, Sum(Invoice.Amount) AS AmountOfSum, Sum(Shippedcontianers.ShipFeeAmount) AS ShipFeeAmountOfSum, ([AmountOfSum]+[ShipFeeAmountOfSum])-[IncomingAmountOfSum] AS CusBalance
FROM ((Customers INNER JOIN Incomingmoney ON Customers.CusID = Incomingmoney.CusID) INNER JOIN Invoice ON Customers.CusID = Invoice.CusID) INNER JOIN Shippedcontianers ON Customers.CusID = Shippedcontianers.CusID
GROUP BY Customers.CusID, Customers.Name;


I have for exemple 3 customers a, b, c
in the table of invoice there is only 3 records means three invoices two of them for customer a and one is for customer c
no record then for b so the query did not retun any thingabout abour customers b but he had incomingmoney and shipped containers and i need the quert to show all to be able to calculate his balance