Query Problem

  • Thread starter Thread starter Dave370
  • Start date Start date
D

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 said:
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?
Click to expand...

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