Returning the existing value

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

Guest

When I do an IIf function and the test is false, I want to return the value
that exists in the field. For example, a field has a value range of 1-14 and
I perform an IIf that says if the value is greater than 14, return 0
otherwise return the 1-14 value in the field.

IFf([Class]>14, 0, what goes here to return the existing value???)
 
When I do an IIf function and the test is false, I want to return the value
that exists in the field. For example, a field has a value range of 1-14 and
I perform an IIf that says if the value is greater than 14, return 0
otherwise return the 1-14 value in the field.

IFf([Class]>14, 0, what goes here to return the existing value???)
Click to expand...

What goes there?

The name of the existing field in square brackets:

IIf([Class]>14, 0, [Class])


John W. Vinson[MVP]
 
Back
Top