I can't seem to get the statement for my query....
IIF(IsNull Like "*" & Forms!frmForm!myfield & "*"
I am normally using the Like statement across the board but I want to make sure that if the field in the table is Null or empty I want to still return all the records for that field. If there is a null field in the table it leaves that record out of the query....I want to make sure I include that record.
Don't know what to parts for the true and false would be?