We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

Access - Cells Containing Key Words

tahirih
tahirih asked
on
Medium Priority
207 Views
Last Modified: 2012-05-11
Hi,

Based on Table A and Table B, I will be creating a query wher I will extract from Table B cells that have key words in A.

In Excel, we use "Contains." Is "Like" the only option in Access - i.e. in Design View, under criteria I enter "Like Red" OR "Like Ball."

Thanks
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2016

Commented:
create a query like this

select * from tableB, tableA
where TableB.field1 like "*" & tableA.field1 & "*"

Author

Commented:
In Access - how can I create this query so that the output table will be based on a word(s) contained in Table A.

Example - Table A has three rows

"The dog jumps"
"The cat jumps"
"The dog jumps and leaps"

I want to search on "jumps" and "leaps", and the output table should have the first and third statements. "Like" does not work.

Thanks

Author

Commented:
Sorry - let me clarify, I am only using Table A to generate the output table.

How can I do this in design view?

Author

Commented:
The code version I have of this is not working either. Thanks
CERTIFIED EXPERT
Top Expert 2016
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
Scott McDaniel (EE MVE )Infotrakker Software
CERTIFIED EXPERT
Most Valuable Expert 2012
Top Expert 2014

Commented:
Given your 3 records:

"The dog jumps"
"The cat jumps"
"The dog jumps and leaps"

Searching for "jumps" OR "leaps" would return all records.

Searching for "jumps" AND "leaps" would return one record.

So I'm not sure how you would return only the 1st and 3rd records using the keywords "jumps" and "leaps", unless you also EXCLUDE the keyword "cat".

In other words, you need to more fully define what you want to do.

Author

Commented:
Thank you
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.