display even if no entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I made a query for an invoice. It has several tables in it. One of the tables
is the items that the customer purchased, and one is how they paid.

The problem is, not all of the customers have paid, but I would like to
generate the invoice, so that if they haven't paid, the "Amount Paid" is $0,
but, because there are no entries for these records in the "paid By" table,
the records of the customers that haven't paid don't show up in the query or
on the report at all.

What should I use for criteria to show the record on the report even if
there is no entry in the payments table?
 
I made a query for an invoice. It has several tables in it. One of the tables
is the items that the customer purchased, and one is how they paid.

The problem is, not all of the customers have paid, but I would like to
generate the invoice, so that if they haven't paid, the "Amount Paid" is $0,
but, because there are no entries for these records in the "paid By" table,
the records of the customers that haven't paid don't show up in the query or
on the report at all.

What should I use for criteria to show the record on the report even if
there is no entry in the payments table?

Select the Join line to the payments table in query design view, and
view its properties. Select Option 2 - "Show all records in Invoices
and matching records in [Paid By]" or something similar.

The amount paid will be NULL if there are no records in the joined
table; you can use the NZ() function to display this as zero.

John W. Vinson[MVP]
 
Back
Top