Query Problem

[Dave370]

Hi,
I have 2 tables, Invoices and Payments. Both have Primary Keys which are
Auto numbers. The Payments Table has a Field in which you can select the
Primary Key of the Invoice Table and another field for the payment amount.

If I create a query to display the Invoice ID (Primary Key of Invoice Table)
and the sum of Payments for the Invoice, Invoices with no payments will not
be displayed. How can I create a query that displays the Invoice Number even
when there are no payments for that Invoice?

 

[Dave370]

This worked, thanks
--
Dave

Double click the join line in your current query and read the descriptions of
the three choices that come up.