IIf statement

[Rhubie]

I have this expression



IIf(Mid([WBCode],4,1)="D",([WBCost]+[WBShipping])*[ExchangeRate],[WBCost]*[ExchangeRate])

I need to add another IIf statement and I am not sure how to add it -

I have have another statement that says IIf(Mid([WBCode, 4,1)="W", ([WBCost]+1% of WBCost......

Do I use a or IIf? I want it to do what is is doing for D, and something else for W

[orange]

IIf(Mid([WBCode, 4,1)="W", ([WBCost]+1% of WBCost......

Fir an IIF statement ,you need a value if the condition is True, and a value if the condition is False

IIf (condition, True, False)

so what are the TRUE and FALSE values?

And what does this mean in plain English?

([WBCost]+1% of WBCost......

[ssanfu]

It is easier to start out with just the IIF() syntax, then add the conditions and expressions. It sounds like you want to use 2 nested IIF() statements. So start with:

IIF(condition, TRUE, FALSE)

Then add the second IIF():

IIF(condition, TRUE, IIF(condition, TRUE, FALSE))

Now add the condition for the first (outer) IIF():

IIF(Mid([WBCode],4,1)="D", TRUE, IIF(condition, TRUE, FALSE))

then the TRUE part:

IIF(Mid([WBCode],4,1)="D", ([WBCost]+[WBShipping])*[ExchangeRate],[WBCost]*[ExchangeRate]), IIF(condition, TRUE, FALSE))

the FALSE part is the nested IIF() function , so
now add the condition for the inner IIF(), then the TRUE clause and the FALSE clause:

IIF(Mid([WBCode],4,1)="D", ([WBCost]+[WBShipping])*[ExchangeRate],[WBCost]*[ExchangeRate]), IIF(condition, TRUE, FALSE))

[Rhubie]

I have the if statment working for if the letter is D do this, but if the letter is W do something else - how do I add the second part of it.

Should I be using something other than an IIF statement

[Rhubie]

I actually have three things that I am looking for

If D do this
If W do this
If anything else do this

[Rhubie]

I'm missing something - and I'm not sure what?

IIF(Mid([WBCode],4,1)="D", ([WBCost]+[WBShipping])*[ExchangeRate],[WBCost]*[ExchangeRate]), IIF(Mid([WBCode],4,1)-“W”,([WBCost]+([WBCost]*.01)*[ExchangeRate],[WBCost]*[ExchangeRate]))

[orange]

IIF(Mid([WBCode],4,1)="D",([WBCost]+[WBShipping])*[ExchangeRate],IIF(Mid([WBCode],4,1)=“W”,([WBCost]*1.01)*[ExchangeRate],[WBCost]*[ExchangeRate]))
.......condition.................... ----------------TRUE-------------------::::::::::::::::::::::::::::::::::::::FALSE::::::: ::::::::::::::::::::::::::::::::::::::::::::::::::
.................................................. .................................................. .......Condition2..............True part.................................|......False part................

[RayMilhon]

Just to be clear.

Using regular If then statements

If D Then
    Do this
Else
    If W Then
         Do This
    Else
         Do This
    End if
End if

Assuming that's what you want then look at Steve's message above.

If we break down your IIF Statement

IIF(Mid([WBCode],4,1)="D", ([WBCost]+[WBShipping])*[ExchangeRate],[WBCost]*[ExchangeRate]), IIF(Mid([WBCode],4,1)-“W”,([WBCost]+([WBCost]*.01)*[ExchangeRate],[WBCost]*[ExchangeRate]))

IIF(Expression = Mid([WBCode],4,1)="D"
True part = ([WBCost]+[WBShipping])*[ExchangeRate]
False part = [WBCost]*[ExchangeRate])

This is where the IIF Statement ends

The rest of this will error
,IIF(Mid([WBCode],4,1)-“W”,([WBCost]+([WBCost]*.01)*[ExchangeRate],[WBCost]*[ExchangeRate])) 

[Rhubie]

I'm getting this error

The expressions you entered contains invalid syntax, or you need to enclose your text data in quotes.

You may have entered an invalid commoa or omitted quotation marks. For example, if the Default Value property of a text fiels is "Huey, Louie, and Dewey, .....

[Rhubie]

Yes the regular If statement is what I want to do - can I do this in an expressions?

[Rhubie]

is there a way to else?

[Rhubie]

I guess my questions is - is there a way to do this in Access 2010?

[orange]

Did you try the expression I gave in post 7?
I adjusted the statement and syntax to match what you said in post 6.

[Rhubie]

It is working - thank you so much for your time - this has been very frustrating

[orange]

Glad you have it working.
Good luck with your project.