Solve : Microsoft Access 2013- Help with Query Criteria?

1.	Solve : Microsoft Access 2013- Help with Query Criteria?
Answer» Hi, I am fairly new to Access and am trying to Omit two words from a query search. It works when I use the criteria [Not Like ("elementary")] to eliminate the word elementary. I also need to Omit the word SCHOOL and Schools as well. I do not want any result to return if they contain these three words. So I do not want to SEE "Dawson School" or "Lincoln Elementary" or "Academy Charter Schools". I cannot seem to figure this out. Please help! Thanks! JohnYou have Microsoft Access 2013, which has some help built-in Here are some guides that might help: Examples of Access query criteria Quote Doesn’t have the specified string, such as KOREA *Not Like "Korea"* For all countries/regions that do not contain the string "Korea". Note the use of quotation marks, not parentheses. Also: Query criteria quick reference guide Does that help any? I'm not familiar with Access itself but in other databases you would add a second not like clause and and then together. So you would have something that reads as "not like x and not like y"Yes! Thanks guys! The quick reference guide is great and the "not like" before each word is what worked. There are not too MANY better feelings than finally figuring out a computer issue

Answer»

Hi, I am fairly new to Access and am trying to Omit two words from a query search. It works when I use the criteria [Not Like ("*elementary*")] to eliminate the word elementary. I also need to Omit the word SCHOOL and Schools as well. I do not want any result to return if they contain these three words. So I do not want to SEE "Dawson School" or "Lincoln Elementary" or "Academy Charter Schools". I cannot seem to figure this out. Please help! Thanks!

JohnYou have Microsoft Access 2013, which has some help built-in
Here are some guides that might help:
Examples of Access query criteria
Quote

Doesn’t have the specified string, such as KOREA

Not Like "*Korea*"

For all countries/regions that do not contain the string "Korea".

Note the use of quotation marks, not parentheses.
Also:
Query criteria quick reference guide

Does that help any?
I'm not familiar with Access itself but in other databases you would add a second not like clause and and then together. So you would have something that reads as "not like x and not like y"Yes! Thanks guys! The quick reference guide is great and the "not like" before each word is what worked. There are not too MANY better feelings than finally figuring out a computer issue

Solve : Microsoft Access 2013- Help with Query Criteria?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment