Multiple Functions in one field

[staholly]

I need to be able to create a multiple function that will return 3 different outcomes for example: if column A =1 than return value "Help" or if column A=2 return value "Stop" or if Column A=3 return value "More". Is this still a iff statement or do I use another function? If so, how do I write it?

 

[jdraw]

see this for info and example
http://www.techonthenet.com/access/functions/advanced/choose.php

 

[vbaInet]

You can use Choose():

Choose([FieldA], "Help", "Stop", "More")

 

[vbaInet]

see this for info and example
http://www.techonthenet.com/access/functions/advanced/choose.php

You got there before me

 

[staholly]

Please explain further. with choose I have to decided the postion i want to be return, right? What I need to do is to be able to return 3 different values. If a>b="Hoop" a=b="stop" a<b="Help". I can't use a iff statement because it only returns 2 values. I need 3 or more values returned.

 

[Taruz]

I need to be able to create a multiple function that will return 3 different outcomes for example: if column A =1 than return value "Help" or if column A=2 return value "Stop" or if Column A=3 return value "More". Is this still a iff statement or do I use another function? If so, how do I write it?

Try this..:

switch([A]=1,"Help",[A]=2,"Stop",[A]=3,"More")

 

[jdraw]

Did you look at the example at the link posted

http://www.techonthenet.com/access/functions/advanced/choose.php

Please explain further. with choose I have to decided the postion i want to be return, right? What I need to do is to be able to return 3 different values. If a>b="Hoop" a=b="stop" a<b="Help". I can't use a iff statement because it only returns 2 values. I need 3 or more values returned.

 

[vbaInet]

The requirement changed. You should have mentioned this in your initial post.

You can use Switch that Taruz suggested but in this form:

Switch(a>b="Hoop", a=b="stop", a<b="Help")

Search the website that jdraw suggested for the Switch function to understand what it does.

 

[staholly]

Yes, I did. Unless I'm missing something, which I could very well be, I don't see anything that applies to what I need.

 

[vbaInet]

Yes, I did. Unless I'm missing something, which I could very well be, I don't see anything that applies to what I need.

That was because your requirement changed. You missed my last post

 

[staholly]

Ok this is what I have entered into the query Switch([BilledAmount]<[Final EOB Amount]="partial",[BilledAmount]=[Final EOB Amount]="approved",[Final EOB Amount]=0="denied"). However, I am getting a error message. What am I doing wrong?

 

[staholly]

It works I just left out another formula. Thanks!!!!!!

 

[vbaInet]

Good to know!!!

I hope you noticed this part of your code that's wrong

[Final EOB Amount]=0="denied")

That should have been a comma (,).