V
Van T. Dinh
You probably exceed the limit of 1024 characters in a cell
in the Query Grid. Also, I think you meant the nested IIf
() function, NOT If statement.
I would even try with 3 nested levels. Write a UDF (User-
Defined Function) using If statements and then use the UDF
in your Query.
HTH
Van T. Dinh
MVP (Access)
in the Query Grid. Also, I think you meant the nested IIf
() function, NOT If statement.
I would even try with 3 nested levels. Write a UDF (User-
Defined Function) using If statements and then use the UDF
in your Query.
HTH
Van T. Dinh
MVP (Access)