J
JJ
What is wrong with this query criteria...
IIf([forms]![myform]![name] Is Null,Like "*",[forms]![myform]![name])
I'm trying to return all records if the user doesn't input a name ([name] is
null), but if they do type in a name to have the query return only that name.
The Like "*" works alone as a query criteria, but when added into the if
statement it returns no values. It might have something to do with the quotes
in the SQL statement...
Thanks!
IIf([forms]![myform]![name] Is Null,Like "*",[forms]![myform]![name])
I'm trying to return all records if the user doesn't input a name ([name] is
null), but if they do type in a name to have the query return only that name.
The Like "*" works alone as a query criteria, but when added into the if
statement it returns no values. It might have something to do with the quotes
in the SQL statement...
Thanks!