• Ongoing coronavirus / COVID-19 discussion: how is the pandemic affecting your community, workplace, and wellness? 🦠

    Working from home? So are we. Come join us! Cyburbia is a friendly big tent, where we share our experiences and thoughts about urban planning practice, planning adjacent topics, and whatever else comes to mind. No ads, no spam, no social distancing.

Software Computer question Part 2

michaelskis

Cyburbian
Messages
20,175
Points
51
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,970
Points
30
Pretty sure this is the answer, instead of "=" use "like" and add asterisks. Hopefully it is a text field.
 
Top