Adding in a conditional field

[Guest]

I want to include a field that will retun an * next to a field if that field
is <,>,= X value. I don't know the proper expression, any thoughts? Thanks

 

[Rick B]

What is your criteria? you say... <.>,= x that covers all values.

You will have to put an unbound field and place an IF statement in it to
produce an "X" or "" depending on the IF status. You'd have to tell us your
criteria if you need help with that statement, or consult the help file.

Rick B

 

[Guest]

ok lets say

= if [applicable field] = < 70% than "*", ""

Not sure if that helps. Jay

 

[Rick B]

Just create an unbound field and set the value to...

=IIf([applicable field]<=.7, "*", "")


Rick B

ok lets say

= if [applicable field] = < 70% than "*", ""

Not sure if that helps. Jay

What is your criteria? you say... <.>,= x that covers all values.

You will have to put an unbound field and place an IF statement in it to
produce an "X" or "" depending on the IF status. You'd have to tell us your
criteria if you need help with that statement, or consult the help file.

Rick B


Thanks