28-Jul-2006, 08:38 AM
|  | Guest | | | | | | | | | | Re: Two fields different Variables
access newb wrote:
> I have tow fields or columns, what ever you wish to call them.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
>
> The first has products, by name
> Hats, shoes, etc
>
> The second has product definitions
> Hats hunting
> Hats ball
> Shoes low tops
> shoes High tops
>
> I Know this sounds silly, but it is the way my miva matches things,
> In my database, I would like to match these fields via words. Hats =
> Hats etc
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
>
> Is there a way to do this?
>
> access newb
Could you give that to us again. I just don't understand what you want.
What do you mean "match fields via words"
--
Joseph Meehan
Dia duit |
28-Jul-2006, 08:38 AM
| | Guest | | | | | | | | | | Re: Two fields different Variables
Field1 Field2
Joe Hats Hats (auto fill when matched by
keyword)
Tractor Hats Hats
Steel Toe Boots Shoes Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
Steel Toe Shoes Shoes
This is an Example of what I would be looking for |
28-Jul-2006, 08:38 AM
| | Guest | | | | | | | | | | Re: Two fields different Variables
Steel Toe Boots matching Shoes isn't going to happen unless you have a list
of synonyms stored somewhere.
For the others, you can use
WHERE Field1 LIKE "*" & Field2 & "*"
--
Doug Steele, Microsoft Access MVP http://I.Am/DougSteele
(no e-mails, please!)
"access newb" wrote in message
news:85E906DD-9990-4C73-B938-FD7C659A477C@microsoft.com...
>
>
> Field1 Field2
> Joe Hats Hats (auto fill when matched by
> keyword)
> Tractor Hats Hats
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13547
> Steel Toe Boots Shoes
> Steel Toe Shoes Shoes
>
> This is an Example of what I would be looking for
| 
Support Us! Become a Promoter! | | Gurfateh ji, you can become a SPN Promoter by Donating as little as $10 each month. With limited resources & high operational costs, your donations make it possible for us to deliver a quality website and spread the teachings of the Sri Guru Granth Sahib Ji, to serve & uplift humanity. Every contribution counts. Donate Generously. Gurfateh! |
 (View-All)
Members who have read this thread : 0
| | There are no names to display. |
|
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | | | | Tools | Search | | | | | Display Modes |  Linear Mode |
Posting Rules
| You may not post new threads You may not post replies You may not post attachments You may not edit your posts
HTML code is On
| | | |  | » Gurbani Jukebox |  Listen to Gurbani while surfing SPN! | | » Active Discussions | | | | | | |  ਨਾਮਾ Today 06:37 AM 2 Replies, 53 Views | | | | | | | | | | | | | | | | | | | | | | | | » Books You Should Read... | | | |
