Limit on IIF's

[Guest]

Is there a limit on the number of IIF expressions I can use in an Access2K query?

 

[Gina]

I believe the limit is 50 but you can only have 1,024
characters.

Hope that helps...

 

[Duane Hookom]

Whenever I see a statement like this, it raises red flags. I would attempt
to either create a user-defined function or use table records to model the
IIf()s.

--
Duane Hookom
MS Access MVP

Is there a limit on the number of IIF expressions I can use in an Access2K

query?