Query problem

[tom]

I have an invoice table. One field of the invoice table
is linked to a bills table. The bills table is linked to
a suppliers table.

There are bills that match a pattern in the invoice
table and there are some invoices with the pattern with no matching bills.
There is a subset of these matching bills that match a certain supplier.

I want a query that will print all invoices that match the
pattern, and I want to print all the bills that match the
pattern from a distinct supplier.

 

[John W. Vinson]

I have an invoice table. One field of the invoice table
is linked to a bills table. The bills table is linked to
a suppliers table.

There are bills that match a pattern in the invoice
table and there are some invoices with the pattern with no matching bills.
There is a subset of these matching bills that match a certain supplier.

I want a query that will print all invoices that match the
pattern, and I want to print all the bills that match the
pattern from a distinct supplier.

Without knowing what you mean by "a pattern" and a better
understanding of your table contents, I can't see how anyone could
come up with a reasonable answer.

John W. Vinson [MVP]