IIf statements

[awake2424]

Interpretation: IIf([Results]="Not Detected","Sequence analysis reveals no genetic variant in " & [VUS] & " in this sample, IIf([Results)="Detected","Sequence analysis reveals a genetic variant in " & [VUS] & " in this  sample.")

Is this the correct syntax for two IIf statements? Thanks.

 

[jdraw]

Techonthenet is an excellent resource for functions, syntax and examples.

see http://www.techonthenet.com/access/functions/advanced/iif.php

 

[khodr]

Dear Awake,
You statement doesn't look correct,
in my example I will consider you have to combo boxes in a Form.
combo 1 called : Results
combo 2 called : VUS
then Create another combo called : detected and paste the below statement into it, and things should work correct.

=IIf([Results]="Not Detected";"Sequence analysis reveals no genetic variant in " & [VUS] & " in this sample";"Sequence analysis reveals a genetic variant in " & [VUS] & " in this sample.")

in another simple example

IIF([var1]="true";"true";"false")
so the statement is checking if the var1 = true then the result of the detected combo box will be true and if it doesn't = true then the result will be false,

feel free to ask in case you have any other questions.

regards.
khodr.