Criteria on multiple fields

[tijut]

I am attempting to run a query on a table with multiple date fields.
Example:

Position Bloodborne Back Carcinogens
group by count count count

The query will group by position, and each column has dates. My problem is
to have the query count dates in each column based on date criteria, such as
Between #date# and #date#. If I set the criteria in all columns, I get a
blank result. If I set the criteria in just one column, I do not get the
proper result.

Can someone help me? Thankyou.

 

[Rick B]

you need to put the criteria in each cloumn, but on separate LINES. This
creates an "OR" condition. By putting it all on the same line you were
creating an "AND" condition.

 

[tijut]

Thank you Rick!

you need to put the criteria in each cloumn, but on separate LINES. This
creates an "OR" condition. By putting it all on the same line you were
creating an "AND" condition.