querys:

Using ap database, create a query that has two fields Vendor Name and Status.

Status is "Open" if the vendor has an invoice that is not paid, Status is "Paid' if the vendor has an invoice with a payment date entered, and finally, Status is "No Invoice" if the vendor does not have any invoices. Note that it possible for a vendor to appear twice in the results if they have both open and paid invoices.