Software Computer question Part 2

[michaelskis]

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]

Pretty sure this is the answer, instead of "=" use "like" and add asterisks. Hopefully it is a text field.

 

[jordanb]

Yeah, Donk has it, but Like also makes the search case-insensitive.