Query Criteria to Allow Null Values, or One Specific Value If Not Null

[skidawgs]

Hi,

I am trying to write a where statement for my query which will accept all null values for a specific column, as well as any record where the value is "current" in that same column.

Essentially, I assumed that adding the following code to my Sidebar.Form.Filter would allow all null values, and prevent the value from being "Past": strFilter = strFilter & "[Status] <> 'Past' AND "
P.S. I do remove the ' AND ' at the end of my string when compiling the Filter, and have everything in regards to the filter working besides this one part.


This does prevent any 'Past' Status value records from appearing, however it also removes all null status values from the query.

My table structure may help explain some of this:
I have a Candidate Table, a Position Table, and a Candidate_Position Join table between the two because of the m-m relationship. I want the filter to prevent the query from displaying any 'Past' Candidates, however when I implement the above code it also removes all positions that don't have an associated candidate (which is not what I am looking for). I have to add the filter via this vba format in order to keep and build upon the desired functionality.

Any advice would be greatly appreciated, I have been stuck on this for a little bit with no success thus far.

Thank you,
Skid

[CJ_London]

really need to see some example data and the desired outcome from that data but guessing at the requirement you probably want something like

"[Status] <> 'Past' OR [Status] is null"

[skidawgs]

Hi Ajax, thanks for the prompt reply.
That is actually just what I was looking for. Somehow this slipped entirely past me. Anyways, thanks for your help!