Returning the existing value

[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???)

 

[Vsn]

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

? Ok ?

 

[John Vinson]

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???)

What goes there?

The name of the existing field in square brackets:

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


John W. Vinson[MVP]