Hi, how do you add more than 1 expression in the control source
I currently have =IIf([a]="x" And [b]="y","z","")
I want to have the same thing but change x, y & z
Thanks
Hi, how do you add more than 1 expression in the control source
I currently have =IIf([a]="x" And [b]="y","z","")
I want to have the same thing but change x, y & z
Thanks
You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.
Thanks, I thought I would try try & figure it out first before asking but at times it looks confusing.You can't, but you can have a more complicated expression. I saw your other thread, so rather than us try to hit a moving target, why don't you post your actual problem? Posting pieces of it may seem logical to you, but in reality the answer will often change with the question.
What I wantb to do is make a Risk Management thing, a table with 3 Rows (Low/Medium/High) & Coloums Likely/moderate/Unlikely, I have set up these as values on a table as as you can see from the attachment when you choose something a corrosposinding note opens up, I want to put the risk number automatically into another box (See Risk Assessment Given Box), This will also go into a report.
I have done it for 1 setting eg: High & Likely but can not seem to do it for the others moderate/Medium etc....
Any advise would be greatful
I hope I have emplained it easier enough
After further searching & reading I figured out how to put more than 1 expression in I used the following:
=IIf([a]="b" And [c]="d","e",IIf([f]="g" And [h]="i","j",IIf(k]="l" And [m]="n","o")))
This seems to work