Logical operators in Access query
Posted on 2007-03-29
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.