>Hello at alls.
>
>I wonder to know how many IIF nested Can I put inside a query.
>
>TIA.
In my tests, the limit is 10. If you go 11, you get the "SQL Expression is too complex" error. You can, as Hilmar posted, use a UDF. You can also break the query into parts (e.g. first 10 and then the final 6)and UNION them.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao