IIf Statement

[Guest]

I need help to write an "IIF" statement for the following:

I have 4 unbound controls on my form that have values in them that need to
be selected for a calculation depending on specific data in my [LBS] field. I
have another unbound control where the calculation will be. Here's an example:

If [LBS] = < 50 then use "unbound1". If [LBS] = < 100 then use "unbound2".
If [LBS] = < 200 then use "unbound3". If [LBS] = < 300 then use "unbound4".

How would I write this with multiple statements?

 

[tina]

multiple nested IIf() functions would do it, as

IIf([LBS] < 51, [Unbound1], IIf([LBS] Between 51 And 100, [Unbound2],
IIf([LBS] Between 100 And 200, [Unbound3], [Unbound4])))

the above expression assumes that [LBS] will 1) never be Null, and 2) it's
acceptable to use [Unbound4] for any value over 200. i would probably use a
custom function with a Select Case statement instead, really just for ease
of reading; but i couldn't tell you if that would be faster or slower than a
nested IIf, or no appreciable difference.

hth

 

[Guest]

That worked perfectly! Thank you very much!

multiple nested IIf() functions would do it, as

IIf([LBS] < 51, [Unbound1], IIf([LBS] Between 51 And 100, [Unbound2],
IIf([LBS] Between 100 And 200, [Unbound3], [Unbound4])))

the above expression assumes that [LBS] will 1) never be Null, and 2) it's
acceptable to use [Unbound4] for any value over 200. i would probably use a
custom function with a Select Case statement instead, really just for ease
of reading; but i couldn't tell you if that would be faster or slower than a
nested IIf, or no appreciable difference.

hth

I need help to write an "IIF" statement for the following:

I have 4 unbound controls on my form that have values in them that need to
be selected for a calculation depending on specific data in my [LBS] field. I
have another unbound control where the calculation will be. Here's an example:

If [LBS] = < 50 then use "unbound1". If [LBS] = < 100 then use "unbound2".
If [LBS] = < 200 then use "unbound3". If [LBS] = < 300 then use "unbound4".

How would I write this with multiple statements?

 

[Arvin Meyer [MVP]]

You might like to try a Select Case statement:

Select Case [LBS]

Case <= 50
[Unbound1]
Case <= 100
[Unbound2]
Case <= 200
[Unbound3]
Case <= 300
[Unbound4]
Case Else

End Select
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[tina]

you're welcome!

That worked perfectly! Thank you very much!

multiple nested IIf() functions would do it, as

IIf([LBS] < 51, [Unbound1], IIf([LBS] Between 51 And 100, [Unbound2],
IIf([LBS] Between 100 And 200, [Unbound3], [Unbound4])))

the above expression assumes that [LBS] will 1) never be Null, and 2) it's
acceptable to use [Unbound4] for any value over 200. i would probably use a
custom function with a Select Case statement instead, really just for ease
of reading; but i couldn't tell you if that would be faster or slower than a
nested IIf, or no appreciable difference.

hth

I need help to write an "IIF" statement for the following:

I have 4 unbound controls on my form that have values in them that need to
be selected for a calculation depending on specific data in my [LBS] field. I
have another unbound control where the calculation will be. Here's an example:

If [LBS] = < 50 then use "unbound1". If [LBS] = < 100 then use "unbound2".
If [LBS] = < 200 then use "unbound3". If [LBS] = < 300 then use "unbound4".

How would I write this with multiple statements?