iif statement with multiple conditions

[ragsgold]

Hi I am looking in for a iif statement usage mutiple parametres i am doing this in the expression bulder in the queries and trying to put the below argument in a seperate colum with iif statements.

i have a "Sales" colum which has data A,B,C,D,E,F

now my argument is if Sales= "A" or "B" the result should be EUR and if sales ="C" or "D" then result should be AMR and finally if Sales = "E" or "F" the result should "PAC"...

can someone help me in this thanks

[RuralGuy]

To make it easier to maintain and read, why not create a public function in a standard module that uses a Case statement?

[ragsgold]

I am actually new to modules and hence i am trying out this in query i wrote a expression like iif(sales ="eu01" or "eu02","Europe",iif(sales="am01" or am02","AMR",iif(sales="jp01" or "kr01","Pac"))),0) here all these in quotes like eu01,eu02 etc are in the colum sales ...is my statement fine i dont get any error but my result is Europe for all codes!

[RuralGuy]

You have to repeat the field each time like:
[sales] = "eu01" OR [sales] = "eu02","Europe"
...etc

[ragsgold]

Hi Ruralguy thanks a lot your solution worked

[RuralGuy]

Great! Glad I could help.

[langit233]

hi RURALGUY!i need to create also a privilege like to change the password of my users actually i set a user password using visual basic but i want to give them as i have said above, a privilege to change there password with a form please help me! a great help would be very highly appreciated! thanks!nyways, im attaching my access 2007 file here so its up to you to explore that file and hoping to get back to you peepz soon with the answer of my needs.thanks so much!

[RuralGuy]

Please start a new thread and show a link to this thread if you believe it will be useful.