I cant see whats wrong

[ghayman73]

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

 

[SuicidED]

Expr2: iif(isnull([search_term]),[search1],[search_term])

Maybe

 

[vbajock]

or try
iif([search_term]=vbNullString,[search1],[search_term])

 

[ghayman73]

thanks suicidED works a treat