Query help

[HelenP]

Hello,



I have created a database to store details about client debt payments. I want to make a query that shows all clients and whether or not they have made any payments towards their debts.

I have managed to get it to show me all clients, their overall debt figures and the amount they have paid but I cannot get it to show all of the people who haven't made any payments. How do I get the clients to appear in the query even if their payment field is empty?

Thanks in advance

[pbaldy]

It would help to know your table structure and the query SQL, but likely you want to edit the join between the clients table and the payments table. Choose the appropriate "Include all records from...".