Returning the existing value


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

Advertisements

Ad

Advertisements

J

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]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top