I would like to have a field automatically indicate yes or no when comparing the enteries in two separate fields.

for example: "field C" to indicate "YES or

NO" when "field B" has a value that is LESS THAN "field A"

quote:

---

Originally posted by ROBVOIGT:

I would like to have a field automatically indicate yes or no when comparing the enteries in two separate fields.

for example: "field C" to indicate "YES or

NO" when "field B" has a value that is LESS THAN "field A"

---

Set field C's calculation to:

Case( field B < field A, "Yes", "No" )

This will result in "Yes" in field C if field B is less than field A and "No" if field B is greater than or equal to field A.

Chuck

Thanks Chuck!