I have a query with a stack of these for different fields on my "picker" form:
Like Iif(IsNull([Forms]![frmJoblisttemp]![JobDescription]),"*","*" & [Forms]![frmJoblisttemp]![JobDescription] & "*")
They work very well by filtering if there is data in the "picker" field but I cant seam to work out how to achieve the same result with checkbox because a check box can't be null only true or false, there is no "ignore me and include both data types" option.
Can someone help me out please.