Simple Query

G

Guest

I have a field listed with various descriptions of commodities. I'm trying
to find the word "steel" in this field. Some descriptions are steel slabs,
steel coils, etc. I want all of these results by looking for the word
"steel." Help.
 
J

John Spencer

Field: SomeField
Criteria: Like "*Steel*"

More flexible

Field: SomeField
Criteria: Like "*" & [Find what?] & "*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
G

Guest

It worked. Thank you!!!

John Spencer said:
Field: SomeField
Criteria: Like "*Steel*"

More flexible

Field: SomeField
Criteria: Like "*" & [Find what?] & "*"

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Skydiver said:
I have a field listed with various descriptions of commodities. I'm trying
to find the word "steel" in this field. Some descriptions are steel
slabs,
steel coils, etc. I want all of these results by looking for the word
"steel." Help.
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing text fields to find upper case lower case mismatches 3
Lookup problems? 1
Need Excel Function to FIND Text - Help! 4
hellllllp. (- multiple posts b/c of errors posting possibly) 13
Smart four digit sorting procedure 9
Uploading excel data to a table using linked data from two other t 4
HELP! DB Design to later query multiple keywords 3
need help with nested formulas please 3

Top