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?

 

[Rick Brandt]

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?

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

 

[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.