I am trying to create a query and having problems.
I have the following tables/fields:
They are linked by the Supplier and InvoiceNo.
I need a query that would show all fields (Supplier, Invoice, InvoiceDate, InvoiceAmount, PaymentDate) for all records with an InvoiceDate prior to 10/1/2004 that have a PaymentDate on or after 10/1/2004 or that haven't been paid yet (ie. no ApInvoicePay record).
I'd like to do this with a single SELECT statement, if possible.