How to Create a Query for Outstanding Invoices

[Sunnylei]

I have problem with my Outstanding Invoice Statement. Some Invoices are partly paid, some are still not paid. How to create a query for these outstanding invoices? Can someone help.

Thanks

 

[jdraw]

It would help those who would respond if you would include your table structures and show us what you have tried, along with any error/message that you received.

How do you determine if an invoice is "paid"? -- I suggest "paid in full".

 

[Sunnylei]

It would help those who would respond if you would include your table structures and show us what you have tried, along with any error/message that you received.

How do you determine if an invoice is "paid"? -- I suggest "paid in full".

I haven't created Outstanding table yet. It's just a idea since I often receive payment which over or underpaid. It's impossible to allocate those underpaid as fully paid. I have tblTransaction which includes invoices and payments, I also have qryAged Debtor, but I have no idea how to creat query for those underpaid invoices.

Thanks