TERRY--EXPRESSION FORMULA

G

gambler

Sorry Terry
For some reason when I hit enter my question was sent.
I keep getting an error message with the formula.
=IIF(ABS([NDIST]-[NPP1DIS])>1.5,"",[NPP1DIS])
Can you tell me why?
Thanks
ed
 
D

Duane Hookom

Are both field non-null numbers?
Is the name of the control something other than a field name?

--
Duane Hookom
MS Access MVP


gambler said:
Sorry Terry
For some reason when I hit enter my question was sent.
I keep getting an error message with the formula.
=IIF(ABS([NDIST]-[NPP1DIS])>1.5,"",[NPP1DIS])
Can you tell me why?
Thanks
ed

Click to expand...
 
G

gambler

What is a non-null number?
How do I tell what the control is?
Thanks for your help
ed

Duane Hookom said:
Are both field non-null numbers?
Is the name of the control something other than a field name?

--
Duane Hookom
MS Access MVP


gambler said:
Sorry Terry
For some reason when I hit enter my question was sent.
I keep getting an error message with the formula.
=IIF(ABS([NDIST]-[NPP1DIS])>1.5,"",[NPP1DIS])
Can you tell me why?
Thanks
ed

Click to expand...
Click to expand...
 
D

Duane Hookom

NDIST and NPP1DIS are both fields, correct?
Are they numeric fields?
Are there any blank/null values in either of these fields in any of the
records?

An example of a control is a text box.

--
Duane Hookom
MS Access MVP


gambler said:
What is a non-null number?
How do I tell what the control is?
Thanks for your help
ed

Duane Hookom said:
Are both field non-null numbers?
Is the name of the control something other than a field name?

--
Duane Hookom
MS Access MVP


gambler said:
Sorry Terry
For some reason when I hit enter my question was sent.
I keep getting an error message with the formula.
=IIF(ABS([NDIST]-[NPP1DIS])>1.5,"",[NPP1DIS])
Can you tell me why?
Thanks
ed

:
Click to expand...
Click to expand...
Click to expand...
 
Top