I have a very old query that our company has had in place for years upon years. It is not a good query, but it doesnt' matter as it runs at 4am when nothing else runs, so performance is not an issue. The query is what drives a report that prints labels ever morning for our warehouse to put on boxes. So, no user input, just straight data and printing.
However, I am asked to add another clause to this query, but I do not know how to do it.
Basically, I want this:
DateRecd = IIF([LineSerial] Is Not Null,Is Not Null)
That obviously doesn't work, but I'll explain what I'm trying to accomplish.
If the LineSerial field is not blank, then the DateRecd field must have some value in order to return results. If the LineSerial field is blank, then disregard any criteria with the DateRecd field.