Report to include all records

[Guest]

I am a totally new user so excuse my ignorance. I have set up forms and
tables for Invoices and for Payments succesfully. I now wish to run a report
which shows all invoices both paid and unpaid. I have set up in Query fields
from both Invoices (including Total Amount Payable) and Payments (AmountPaid)
and also defined "Paid" as Paid:IIF([TotalAmount
Payable]=[AmountPaid],"Yes","No"). My report based on this Query only
reports the paids and not the unpaids. If an Invoice is unpaid I'm obviously
not filling out a Payment form and hence the corresponding value in Amount
Paid for that invoice is null. I believe I'm supposed to define Null values
however need some help.

 

[Guest]

I am a totally new user so excuse my ignorance. I have set up forms and
tables for Invoices and for Payments succesfully. I now wish to run a report
which shows all invoices both paid and unpaid. I have set up in Query fields
from both Invoices (including Total Amount Payable) and Payments (AmountPaid)
and also defined "Paid" as Paid:IIF([TotalAmount
Payable]=[AmountPaid],"Yes","No"). My report based on this Query only
reports the paids and not the unpaids. If an Invoice is unpaid I'm obviously
not filling out a Payment form and hence the corresponding value in Amount
Paid for that invoice is null. I believe I'm supposed to define Null values
however need some help.

Please ignore - I have at last solved the problem