In design view for the criteria field I need to look for (for example) apples and oranges. How do I add both to my criteria?
"apples" and "oranges"
I tried that above but its not working.
In design view for the criteria field I need to look for (for example) apples and oranges. How do I add both to my criteria?
"apples" and "oranges"
I tried that above but its not working.
but i want both apples and oranges, not OR. I need both.
is my AND statement correct though?
is my AND statement correct though?
or should I use the IN statement to search for two or more values?
What does the data look like? And would normally apply to 2 different fields. One field typically can't be both apples and oranges at the same time.
No record can meet the criteria of "apples and oranges" if the data is in one field - use OR operator, like:
SELECT * FROM Table WHERE field = "apples" OR field = "oranges";
or use IN operator, like:
SELECT * FROM table WHERE field IN ("apples", "oranges");
Review http://www.allenbrowne.com/ser-62.html
Provide sample dataset and desired output.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Looks like June7's going to take over.