When the query is run, I want the user to enter the shift. So, in the Shift field I have the following in the criteria box:
Like "*" & [Enter Shift] & "*"
However, some of the workorders do not have a shift(the box was left blank). The query as is doesn't pick those up. How can I modify it to pick up all shifts even though some are blank?
Like "*" & [Enter Shift] & "*"
However, some of the workorders do not have a shift(the box was left blank). The query as is doesn't pick those up. How can I modify it to pick up all shifts even though some are blank?