need help with a seemingly simple IIF statement

[Scott B]

Greetings,

I write a lot of IIf statements, but for some reason this one is giving me a
fit. Does anyone see my mistake? It is eluding me.

Many thanks,
Scott

= ("Staying for " & (IIf ([StayLength]) = "1", " Night" , " Night(s)"))

 

[Nikos Yannacopoulos]

Scott,

Redundant parentheses, and quotes around 1 while [SatyLength] is
numeric? Try:

= "Staying for " & IIf([StayLength] = 1, " Night" , " Night(s)")

HTH,
Nikos

 

[Steven Greenberg]

Scott,

Redundant parentheses, and quotes around 1 while [SatyLength] is
numeric? Try:

= "Staying for " & IIf([StayLength] = 1, " Night" , " Night(s)")

HTH,
Nikos

Greetings,

I write a lot of IIf statements, but for some reason this one is
giving me a fit. Does anyone see my mistake? It is eluding me.

Many thanks,
Scott

= ("Staying for " & (IIf ([StayLength]) = "1", " Night" , "
Night(s)"))

also do you want it to output something like:

Staying 1 Night
Staying 3 Night(s)

or

Staying Night
Staying Night(s)

if you want the first, then you must also include the StayLength variable
in the statement.

="Staying for " & StayLength & IIf([StayLength] = 1, " Night" , "
Night(s)")

if the second, then the previous suggestion will work.

 

[Van T. Dinh]

If [StayLength] is numeric, you should remove the String delimiters. Also,
some parentheses are not needed and some are wrongly placed.

Try:

= "Staying for " & IIf ([StayLength] = 1, " Night" , " Night(s)")

 

[Scott B]

Nikos,

BINGO!

Thanks,
Scott B

Scott,

Redundant parentheses, and quotes around 1 while [SatyLength] is numeric?
Try:

= "Staying for " & IIf([StayLength] = 1, " Night" , " Night(s)")

HTH,
Nikos

Greetings,

I write a lot of IIf statements, but for some reason this one is giving
me a fit. Does anyone see my mistake? It is eluding me.

Many thanks,
Scott

= ("Staying for " & (IIf ([StayLength]) = "1", " Night" , " Night(s)"))

 

[Guest]

On another point completely, why the parentheses around the "s"? Seems to me
the second choice will only appear if the number is 2 or greater, so plural
is not optional.

Nikos,

BINGO!

Thanks,
Scott B

Scott,

Redundant parentheses, and quotes around 1 while [SatyLength] is numeric?
Try:

= "Staying for " & IIf([StayLength] = 1, " Night" , " Night(s)")

HTH,
Nikos

Greetings,

I write a lot of IIf statements, but for some reason this one is giving
me a fit. Does anyone see my mistake? It is eluding me.

Many thanks,
Scott

= ("Staying for " & (IIf ([StayLength]) = "1", " Night" , " Night(s)"))

 

[Scott B]

just a typo on my part. Forgot to eliminate it.

Thanks,
Scott B

On another point completely, why the parentheses around the "s"? Seems to
me
the second choice will only appear if the number is 2 or greater, so
plural
is not optional.

Nikos,

BINGO!

Thanks,
Scott B

Scott,

Redundant parentheses, and quotes around 1 while [SatyLength] is
numeric?
Try:

= "Staying for " & IIf([StayLength] = 1, " Night" , " Night(s)")

HTH,
Nikos

Scott B wrote:
Greetings,

I write a lot of IIf statements, but for some reason this one is
giving
me a fit. Does anyone see my mistake? It is eluding me.

Many thanks,
Scott

= ("Staying for " & (IIf ([StayLength]) = "1", " Night" , "
Night(s)"))