IIF Statement isn't working

[djclntn]

I'm not sure if (pardon the pun) this thread ought to be in queries or forms. On my Vehicles Info form 2-flds we're focus on is, Bodystyle" and "Drivetrain." Bodystye is a dropdown fld with 5-selection. One of the selections are, "SUV" And with most SUV'S the body style is, "4WD. So I thought why not design an IIfStment in the Drivetrain Query whereby the default value drivetrain is, "RWD", but when I select, "SUV" in body style then "4WD" comes up in the drivetrain fld. Here's the IFF statement I've tried:
Drivetrain: Iff([Bodystyle]="Suv","4WD","RWD).

Not to complicate things, but once someone kindly straightens out my IIF statement, I will want to add an OR to the statement, something like:
Drivetrain: Iff([Bodystyle]="Suv","4WD","RWD":, OR Iff([Bodystyle]="Truck","4X4","RWD")

[pbaldy]

For starters, it's IIf, not Iff. Secondly, you didn't close the quotes on the final argument. An or would look like

Field = "SUV" Or Field = "Truck"

[djclntn]

Yea pd, tried to jump back on & correct myself before anyone replied. Thanks for replying. lI'll work at it tomorrow; I may have more questions. Thanks

[pbaldy]

No problem.

[djclntn]

P, I tried,
"Drivetrain: Iif[Drivetrain]="Suv",[Bodystyle]="4WD","RWD"

[pbaldy]

Did you miss:

Field = "SUV" Or Field = "Truck"

[ssanfu]

PMFJI,

Not to complicate things, but once someone kindly straightens out my IIF statement, I will want to add an OR to the statement, something like:
Drivetrain: Iff([Bodystyle]="Suv","4WD","RWD":, OR Iff([Bodystyle]="Truck","4X4","RWD")

Try:

Drivetrain: IIf([Bodystyle]="Suv","4WD",IIf([Bodystyle]="Truck","4X4","RWD"))

[Ruegen]

PMFJI,


Try:

Drivetrain: IIf([Bodystyle]="Suv","4WD",IIf([Bodystyle]="Truck","4X4","RWD"))

just out of curiosity how come after "4wd" you didn't close the first IIf with the end ) and included the second IIf in the first?

[djclntn]

I copied/pasted exactly what Steve & Ruegen wrote above, Drivetrain: IIf([Bodystyle]="Suv","4WD",IIf([Bodystyle]="Truck","4X4","RWD")). I get an error message saying, "The expression you entered has an invalid . (dot) or ! operator or invalid parentheses."

[ssanfu]

@Ruegen

just out of curiosity how come after "4wd" you didn't close the first IIf with the end ) and included the second IIf in the first?

These are nested IIF() statements.

I start with this in Notepad:

Drivetrain:IIF(test,True,False)

Then I add the conditional part:

Drivetrain:IIF([Bodystyle]="Suv",True,False)

Next add the "result if true":

Drivetrain:IIF([Bodystyle]="Suv","4WD",False)

If the is not "SUV", is if a "Truck"?? Need another IIF() statement. So.. paste in the original IIF() statement in the "result if false" clause

Drivetrain:IIF([Bodystyle]="Suv","4WD",IIF(test,True,False))

Enter the conditional part in the nested IIF():

Drivetrain:IIF([Bodystyle]="Suv","4WD",IIF([Bodystyle]="Truck",True,False))

Add the "result if true":

Drivetrain:IIF([Bodystyle]="Suv","4WD",IIF([Bodystyle]="Truck","4X4",False))

If the body style is not "SUV" and the bodystyle is not "truck", what should be returned??
Now we have:

Drivetrain:IIF([Bodystyle]="Suv","4WD",IIF([Bodystyle]="Truck","4X4","RWD"))

That is how I build nested IIF() statements for wueries



In VBA, the nested IIF() would be written:

    If [Bodystyle] = "Suv" Then
        Drivetrain = "4WD"
    ElseIf [Bodystyle] = "Truck" Then
        Drivetrain = "4X4"
    Else
        Drivetrain = "RWD"
    End If

------------------------------
@djclntn

The expression worked in my query. It has two opening parenthesis and two closing parenthesis, so no extra parenthesis .
There is not a !, so can't be that.
There is no . (dot) in the expression

If you copied and pasted it, the expression should work..