Boolean for idiots

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

Guest

I'm very new to this so forgive this idiotic question.

I've managed to set up a parameter query. However, I don't know how to apply
Boolean operators so that if, for example, "coffee" is in one field and
"report" in the second or third fields, how do I ensure that I get "coffee
report" when I run the query?
 
In query design mode, all criteria on a single line are processed with AND.
Separate lines are processed with OR. Each field has its own parameter,
although they can be the same. So for field1 you'll have [Parameter1], and
for field2 you'll have [Parameter2]. In your case, both should be on the
same line.
 
Back
Top