Google like search engine in ms access

[oladsevilla]

anyone have an idea how to search data in ms access the same as google.

Search Example: age > 40 or height between 50 and 60 cm

please help. Thanks

Olad

[Stewart Ross]

What you ask is not at all easy to implement in any environment. It is not what Access is designed to do at all.

You could implement simpler form filtering or similar searching in Access (see for example these threads linked here: Example filtering by form, Search filter for just one criteria).

Google-like searching looks easy but isn't, and certainly not in a relational database environment where you need to precisely specify the fields to be searched and the values being compared - which is nothing at all like the free-text example you provide.

Stick with what is practicable, not what will be beyond your resources and time to achieve.

-Stewart

[dsatino]

For starters, a Google like search is not practical in this environment, but from your question that's not what you want anyway. Google is a combination of algorithms, regular expressions, geography, frequency of user selections, and many, many other things.

What you need is parameter based query in which case you only need SQL.

For example, if you have a table called "People" and it has the fields: Name,DateOfBirth,Height,Weight
and you wanted to get all people with heigth between 50 and 60 cm then you would write the following SQL statement

SELECT People.Name
FROM People
WHERE People.Height Between 50 AND 60