i am using the iif function in a query
Expr2: iif([search_term]="",[search1],[search_term])
it doesnt show [search1] if there is no value in [search_term] but it will show [search_term] if there is a value.
any sugestions why this shouldnt work.
Grant
Expr2: iif([search_term]="",[search1],[search_term])
it doesnt show [search1] if there is no value in [search_term] but it will show [search_term] if there is a value.
any sugestions why this shouldnt work.
Grant