Problem with Query

[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.

 

[Guest]

See my response to your earlier post on the same subject.

Ken Sheridan
Stafford, England