Re: Database Search with string portion
- From: John Spencer <spencer4@xxxxxxxxxxx>
- Date: Sun, 16 Jul 2006 16:42:05 -0400
SELECT *
FROM SupplierTable INNER JOIN ShortTitles
ON SupplierTable.Name LIKE "*" & ShortTitles.Name & "*"
Or just add the two tables to the query grid with no join and under the Name
field set the criteria to something like the following:
Field: Name
Table: SupplierTable
Criteria: LIKE "*" & [ShortTitles].[Name] & "*"
Ananth wrote:
.
IN MS Access Query Design Mode
We have 2 tables
Table-1 Supplier Table with Full Address â?? Mutlifields (Name, Address,
email etc)
Table-2 Short Title Supplier â??Single field
Example1) Sony International, Sony Local, Global Sony, J-Sony-Singapore as
supplier name in Table A
2) Pepsi Holdings, Pepisico, Singapore Pepsi as supplier name in Table 2
These 2 companies have short names as Sony, Pepsi in Table 2.
Using MS Access Query in Design Mode , how do I link these 2 tables and
extract data from Table-1 for Sony, Pepsi
My search normally at a time is to look for data in Table-1 for 50 Short
name suppliers.
Any help will ge greatly appreciated.
- Prev by Date: Re: combine valu es from 2 fields
- Next by Date: Re: Query To Retrieve Less Than or Equal To
- Previous by thread: combine valu es from 2 fields
- Next by thread: Re: Query To Retrieve Less Than or Equal To
- Index(es):
Relevant Pages
|
|
