TERRY--EXPRESSION FORMULA

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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...
 
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...
 
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...
 
Back
Top