Query Problem

[tom]

I have an invoice table. The invoice table is associated with the bills
table by a text column in each. The bills table is linked to a suppliers
table.

I want to print all the invoices that have a certain
text pattern. Some bills are associated with these
invoices and some are not. A subset of these associated
bills are from a certain supplier.

I want to print all the invoices that have a certain
text pattern, and also the associated
bills from a certain supplier using one query.

 

[Brendan Reynolds]

Sounds like the 'LIKE' operator might be part of the solution to your
problem. Here's a link to the on-line help topic ...

http://office.microsoft.com/assistance/hfws.aspx?AssetID=HP010322531033&CTT