Insert the word red, green or yellow based on a value

[Guest]

I am trying to insert a word like "Green" if the value is <1 or red if the
value is >2 but less < 3 or Red if the value is >3.

Can someone help?

Thank You

AL

 

[Douglas J. Steele]

What do you want if the value is between 1 and 2? I'm going to assume that
what you meant to say was you want Green if the value is < 1, Yellow if the
value is >= 1 and <= 3, and Red if the value is > 3. Set the ControlSource
of the text box to the following (including the = sign):

=IIf([MyValue] < 1, "Green", IIf([MyValue] <= 3, "Yellow", "Red"))


(replace [MyValue] with the actual field name)

 

[Guest]

Works Fantastic,

Thank you...

AL

What do you want if the value is between 1 and 2? I'm going to assume that
what you meant to say was you want Green if the value is < 1, Yellow if the
value is >= 1 and <= 3, and Red if the value is > 3. Set the ControlSource
of the text box to the following (including the = sign):

=IIf([MyValue] < 1, "Green", IIf([MyValue] <= 3, "Yellow", "Red"))


(replace [MyValue] with the actual field name)

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

I am trying to insert a word like "Green" if the value is <1 or red if the
value is >2 but less < 3 or Red if the value is >3.

Can someone help?

Thank You

AL