 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / General 2 / February 2007Query Problem
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. 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  SignatureBrendan Reynolds Access MVP >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 [quoted text clipped - 8 lines] > text pattern, and also the associated > bills from a certain supplier using one query. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.