Problem with Query

  • Thread starter Thread starter tom
  • Start date Start date
T

tom

SELECT Invoice.[Invoice Number], Invoice.[Your Order #], Payables.[Supplier
Number]
FROM Payables right JOIN Invoice ON Payables.[Number] = Invoice.[Invoice
Number]
WHERE (((Invoice.[Your Order #]) Like "*TEXT*") AND ((Payables.[Supplier
Number])="TEXT1"))
ORDER BY Invoice.[Your Order #];

I want the query above to include all the invoices that
match text, some of these do and some of these dont
have a payable matching them. When the payable matches I want it to print
and when there is no matching
payable, I still want only the invoice to print.

The above query only prints invoices with matching
payables.
 
Back
Top