How many if statements can be nested together?

[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)