G
Guest
I have one half of the result I'm looking for in a calculated field in a
query. Here's the half that works:
Calclo1: IIf([LO1]=True And [Action]="Enable","Y")
What I want to add is the value when Action is "Disable", which is "N". If I
need to, I can add a false value of "". I've tried IIf...Then, Else IIf..Then
as well as the following -- all of which generated errors.
Calclo1: IIf([LO1]=True And [Action]="Enable","Y"), IIf([LO1]=True And
[Action]="Disable" ,\"N"), ""))
Can someone help get me on the right track? Would sure appreciate it.
query. Here's the half that works:
Calclo1: IIf([LO1]=True And [Action]="Enable","Y")
What I want to add is the value when Action is "Disable", which is "N". If I
need to, I can add a false value of "". I've tried IIf...Then, Else IIf..Then
as well as the following -- all of which generated errors.
Calclo1: IIf([LO1]=True And [Action]="Enable","Y"), IIf([LO1]=True And
[Action]="Disable" ,\"N"), ""))
Can someone help get me on the right track? Would sure appreciate it.