0

mulitple "IF"

Hi,

I need to write an "IF" query that has more than just one "IF" and dont know how and cant find an example, maybe it isnt possible in JET?? I need to say =IF field A is =1 then…, if field A is = 2 then…, if field A is =3 then…. else…

the only "IF" function I can use succesfully is the =IF(logical test, value if true, value if false), how can I use this with multiple IF's?

thanks,
K

8 comments

Please sign in to leave a comment.