Software 💾 Computer question Part 2

michaelskis

Cyburbian
Messages
20,906
Points
57
OK I know I am a little rusty on Access, I found a form that has a search engine, but it requires that the text be exactly. How do I search for part of text?

Here is the SQU statement. (Attorney Opinion is the table, and Location Type is a field and “Lake” is the text in the record)


Select * from [Attorney Opinion] Where [Location Type]="Lake"

What do you think???

Mod note - thread moved.
 

donk

Cyburbian
Messages
6,961
Points
31
Pretty sure this is the answer, instead of "=" use "like" and add asterisks. Hopefully it is a text field.
 
Top