• Cyburbia is a friendly big tent, where we share our experiences and thoughts about urban planning practice, the built environment, planning adjacent topics, and anything else that comes to mind. No ads, no spam, and it's free. It's easy to join!

Software 💾 Computer question Part 2

michaelskis

Cyburbian
Messages
21,332
Points
61
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