Limit on IIF's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a limit on the number of IIF expressions I can use in an Access2K query?
 
I believe the limit is 50 but you can only have 1,024
characters.

Hope that helps...
 
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


Perico said:
Is there a limit on the number of IIF expressions I can use in an Access2K
Click to expand...
query?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Query problem 1
Access My Expression Contains Wrong number of arguments 0
Help Needed: Create Sum in Report Footer based on aggregate expression 1
iif statement what is wrong with this expression 2
Nested IIf stops after two conditions 8
Multiple IIf's 6
iif and between 3
IIf statement Query 17

Back
Top