Adding in a conditional field

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Just create an unbound field and set the value to...

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


Rick B


Jason said:
ok lets say

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

Not sure if that helps. Jay

Rick B said:
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
Click to expand...
Click to expand...
 
Back
Top