• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1093
  • Last Modified:

Logical operators in Access query

Obviously, logical operators are different between Excel and Access.  I'm only used to the former, and I'm tired of guessing about the latter.  I need an answer ASAP.

I have a query that, for a date field, should pull records if that field is (a) blank or (b) between X & Y.  X & Y are input prompts, so criteria is....>=[X] AND <= [Y].  Tagging on the following never seems to include the blank dates....OR IsNull([fieldname]).  I've tried everything I can, but I don't think I'm understanding how to program "([X] AND [Y]) OR [Z]" into Access.

Help, please.
1 Solution
WHERE datefield Is Null OR datefield Between [x] And [y]
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now