OR statements in queries?

  • Thread starter Thread starter elisemack
  • Start date Start date
E

elisemack

I have a table where I have checkboxes to show daily attendance. I
have a box for Monday, Tuesday, Wednesday, and Thursday. I want to
run a query that will return anyone who attended at least one of these
days. I know how to run a query of those who just attended on Monday,
Tuesday, etc., but I don't know how to structure the query so that it
will return any record that attended at least one time, not showing
those with no attendance. I guess I want something like an OR
statement, but I can't figure out how to do that in the query
design.I'm hoping that this can be done, but I'm at the end of my
knowledge.

Thanks for any help,
Elise
 
In the QBE grid, criteria that are placed on the same line are combined with
the AND operator. Criteria that are placed on different lines are combined
with the OR operator. So place your Sunday test on line 1, Monday on line
2, Tuesday on line 3, etc. Remember if there are other criteria, they MUST
be repeated on each row.
 
Back
Top