Keyword searches

[Guest]

I have an .mdb which has fields that will contain keywords. For example:
Field_1 might contain the keywords: Skull, fracture, ocipital

How do I set up a an SQL query (or a find/seek command) to locate all
records which contain the keywork "fracture" in Field_1 ? (I'm using a VB
form as the interface.)

 

[Al Campagna]

MCForensic,
If the word "fracture" is included with other text in Field1 (ex. Skull,
fracture, ocipital) you can locate these using the Like operator in your
Field1 Query criteria.

Field1
Like "*" & "fracture" & "*"

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."

 

[Guest]

Thanks! Short, weet and to the point!

MCForensic,
If the word "fracture" is included with other text in Field1 (ex. Skull,
fracture, ocipital) you can locate these using the Like operator in your
Field1 Query criteria.

Field1
Like "*" & "fracture" & "*"

--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."