G
Guest
How do I query using a phrase *me and you*. I do not want the word "and" to
be an operator. Thanks.
be an operator. Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
M
MGFoster
Trudy said:How do I query using a phrase *me and you*. I do not want the word "and" to
be an operator. Thanks.
Use quotes:
Criteria: "*me and you*"
V
Van T. Dinh
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.
delimiters " and it will be treated as part of the String, _not_ as a
logical operator.
G
Guest
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*"
logical operator. After entering the phrase (enclosed by *s), I get this:
Like "*you" And Like "me*"
F
fredg
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*"
Like "*Me and you*"
on one line works for me (though the grammar bothers me. Perhaps you
should try
Like "*You and I*" <g>
V
Van T. Dinh
No. You have to enter:
Like "*you and me*"
including the double quotes as String delimiters.
Like "*you and me*"
including the double quotes as String delimiters.
G
Guest
That's the ticket! I manually entered the quotes rather than letting Access
do it automatically. Bingo! Thanks!
do it automatically. Bingo! Thanks!