Querying for phrase that includes the word And

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I query using a phrase *me and you*. I do not want the word "and" to
be an operator. Thanks.
 
Trudy said:
How do I query using a phrase *me and you*. I do not want the word "and" to
be an operator. Thanks.
Click to expand...

Use quotes:

Criteria: "*me and you*"
 
The 'And' in the criteria Like "*me and you*" is _inside the String
delimiters " and it will be treated as part of the String, _not_ as a
logical operator.
 
I entered it as *me and you* and got zero results. It is being treated as a
logical operator. After entering the phrase (enclosed by *s), I get this:

Like "*you" And Like "me*"
 
I entered it as *me and you* and got zero results. It is being treated as a
logical operator. After entering the phrase (enclosed by *s), I get this:

Like "*you" And Like "me*"
Click to expand...

Like "*Me and you*"

on one line works for me (though the grammar bothers me. Perhaps you
should try

Like "*You and I*" <g>
 
No. You have to enter:

Like "*you and me*"

including the double quotes as String delimiters.
 
That's the ticket! I manually entered the quotes rather than letting Access
do it automatically. Bingo! Thanks!
 
You must log in or register to reply here.

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

Criteria of parameter queries 2
concatenation multiple columns, & removing phrase and replacing wi 2
How to query 2 tables and then perform a wildcard search using a 3 1
MID Function 1
Google Removes 'Don't Be Evil' Clause From Its Code of Conduct 1
Exclude phrase from email 0
Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
The VAC system voice controll for pc's 4

Back
Top