Fulltext search

J

Jerico Tolentino

Hi,

I used MySQL previously as my database, but now I'm shifting to Microsoft
Access. I was wondering if I could do fulltext search with boolean operators
as well here, since I have users who just type whatever words come to mind.
So is there a way to do this in Access? I'm using Access 2007 Beta.

Thanks in advance!
 
A

Allen Browne

Welcome to Access.

When viewing a form or datasheet (table, query, ...), click the Find button
on the toolbar (binocular icon). The dialog has options to search just the
field or all fields, whole-field match, start-of-field match, or
anywhere-in-field match.

In a query, use the Like operator with the * wildcard to search for a word
in a field in Access. In query design, enter something like:
Like "*dog*"
to find dog anywhere in the field, or:
Is Null Or Not "*dog*"
to find the rest.

If you are trying to programmatically create a Filter for a form or
WhereCondition for OpenReport, you can download a small sample database that
shows how to create a search form from this new article:
Search Database: how to handle many optional criteria
at:
http://allenbrowne.com/ser-62.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...
 
Top