I am trying to set the query to only show job without an end date. Is null does not work. I feel I should know this but I am stuck.
I am trying to set the query to only show job without an end date. Is null does not work. I feel I should know this but I am stuck.
IIf ([YourEndDateField] & "") = "")
...which covers both Null and ZLS
No that is not it, I only need to show jobs where the Enddate is not empty, thereby elimination closed jobs.
I'm confused. In post #1 you say "show job without an end date" and now you say "where the Enddate is not empty". Which is it?
Sorry, you are right, where the enddate is empty.
Today is another day and it decided to work for me. The criteria for enddate now accepts: is null
and now shows only open job.
So is this thread ready to be marked as Solved?