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
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
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
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.
