Query A part description /name

[wvswede]

Hello Everyone,

I am setting up a database for making it easy to find parts( I thought)

The problem im running into is that the partname / description could be for instance : "Gasket, Left head" well if they search for "Gasket" they are going to find everything that starts with gasket not a big deal if you just click through the finding until you find what you are looking for.

The problem is if anyone search by the common name "Head gasket" since its not written the exact same way it will not find it. Right now im using the "find" function through the Command button wizard.

So what I need help with is a function to look for any word in any order. If its part of the description it will find it



Greatful for any help or guidance anyone can offer.

[RuralGuy]

You will need to use the Like operator and the wildcard character "*".

[wvswede]

Thnx RuralGuy,

Already tried that though Like "*" & [Partname] & "*"
If I enter the partname excactly like it was entered into the Database

Gasket, Left Head

the query will find what I am looking for, but the common name is

Head Gasket

This it will not find.

Is there any way around this where it will look for either order of the words, I would hate to have to re enter all the data in the database.

Thanks,

[RuralGuy]

And what happens if you look for just Gasket?

[wvswede]

Searching just Gasket it finds it, after a few scrolls through the results

as well as Searching just on Head and also when searching on Left.

Its when you for some reason would search for head Gasket wich is the common name, where the words are backwards compared to the data in tables....

This is not a big thing though I got 1000's of records that would have to be altered if I want to change it to actually say Left Head Gasket and so on.....

Thought maybe there would be a command for the query where it would actually ignore the order of the words in the table, but i guess no such luck

[RuralGuy]

I wonder how Google does it?