I'm trying to create a query by form query. I would have thought the syntax within the query would have been as follows but it's not working.
IIf([forms]![frmQBFRenewal]![Combo14]=Yes,Like "*", Is Null)
The field that I am querying is a date field. If Combo14 is set to Yes then I don't care what dates are in the field. I want all data returned including records with no dates. If Combo14 is set to NO then I only want records that have no date entry in the field I'm querying.