legendv
06-04-2002, 08:05 AM
In a query doing an iif statement, with 11 conditions, it says my expression is too complex. Is there a way around that?
|
View Full Version : Expression is too complex? legendv 06-04-2002, 08:05 AM In a query doing an iif statement, with 11 conditions, it says my expression is too complex. Is there a way around that? RV 06-04-2002, 08:21 AM One of the things you could do is to follow the suggestion made by DavidR in one of your former posts: http://www.access-programmers.co.uk/ubb/Forum3/HTML/003841.html RV legendv 06-04-2002, 02:44 PM Or use switch! Switch([isize]<0,0+[exutiss],[isize]<0.3,1+[exutiss],[isize]<0.7,2+[exutiss],[isize]<=1,3+[exutiss],[isize]<2.1,4+[exutiss],[isize]<=3,5+[exutiss],[isize]<=4,6 +[exutiss],[isize]<=8,7+[exutiss],[isize]<=12,8+[exutiss],[isize]<=24,9+[exutiss],[isize]>24,10+[exutiss]) I don't know how many conditions it can hold, but it was all done in a query! Thanks for your help! |