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?
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?