By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,389 Members | 2,010 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,389 IT Pros & Developers. It's quick & easy.

Google like search engine in ms access

P: 3
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

May 26 '12 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
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.

May 26 '12 #2

P: 393
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
Jun 1 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.