query of Payment Controlling, help...

[Ayas]

I have a Debitur table the primary key is Debitur ID and a Payment table has Debitur ID field as the child key.
The Payment table tells people recorded in the Debitur table who has pay the loan . How to make a query of people recorded in the Debitur table who hasn't pay the loan ?
Any people help me please...thank for your helps of course....

 

[Rich]

Sum(AmountDue) -Sum(AmountPaid) will give you the balance

 

[Ayas]

Not Operational syntax

Thanks for your answer friend, but I didn't ask about making an operational syntax in the query to get the saldo or the amount of the loan left, but I wanted to make a table from a query that only contained people in the Debitur table who hadn't paid the loan yet. You know the Payment table only shows the payment, and who (Debitur) has pay the loan, for example for each months. I was confused about making a table from a query that only showed people in the Debitur table who hasn't paid the loan.
if you have the answer please help me...and thanks again...

 

[simongallop]

Presuming the following:

Table Name: Debitur
Field: [Debitur ID]
Field: [Name]

Table name: Payment
Field: [Debitur ID]

Try this query:

SELECT Debitur.[Debitur ID], Debitur.[Name]
FROM Debitur LEFT JOIN Payment ON Debitur.[Debitur ID] = Payment.[Debitur ID]
WHERE Payment.[Debitur ID] Is Null;

HTH