Hi All
My first post so sorry if its a bit of simple one, I've been reading through previous posts but can't seem to get this to work.
I have a Query to return information based on 3 criteria from information held in 2 different columns of a table named CD, the first column in the query is titled DOD which is a date field and the second titled MO a Yes/No field
In the DOD Column criteria I have the simple formula
>=[Report From] Or Is Null
Gives me a start date and includes any blanks in the column, this works fine however when I try to add the third criteria that is to also only return records where MO = Yes
If I remove the DOD formula, the MO query correctly returns the YES only results and If I remove the MO Yes criteria the DOD works correctly, I just cannot get them to work together? :banghead:
Thanks in advance!
My first post so sorry if its a bit of simple one, I've been reading through previous posts but can't seem to get this to work.
I have a Query to return information based on 3 criteria from information held in 2 different columns of a table named CD, the first column in the query is titled DOD which is a date field and the second titled MO a Yes/No field
In the DOD Column criteria I have the simple formula
>=[Report From] Or Is Null
Gives me a start date and includes any blanks in the column, this works fine however when I try to add the third criteria that is to also only return records where MO = Yes
If I remove the DOD formula, the MO query correctly returns the YES only results and If I remove the MO Yes criteria the DOD works correctly, I just cannot get them to work together? :banghead:
Thanks in advance!