Another equation almost done now

[stryder09]

Okay I am trying to use the following equation but keep getting back the error
The expression you entered contains invalid syntax.
You may have entered a comma without preceding value or identifier

the equation

=IIF(AND([DeadPinRecoveryTopMeasured]>=[DeadPinThicknessMIN],[DeadPinRecoveryTopMeasured]<=[DeadPinThicknessMAX]),0,IIF(AND([DeadPinRecoveryTopMeasured]+2>=[DeadPinThicknessMIN],[DeadPinRecoveryTopMeasured]-2<=[DeadPinThicknessMAX]),2,IF(AND([DeadPinRecoveryTopMeasured]+4>=[DeadPinThicknessMIN],[DeadPinRecoveryTopMeasured]-4<=[DeadPinThicknessMAX]),5,20)))

Again any help would be apprciated. I feel a little bit out of my element with the equation aspect of all of this.



thanks,

Brad

[pbaldy]

Access does AND & OR differently than Excel. In Access:

=IIF(OneThing OR Another, This, That)
=IIF(OneThing AND Another, This, That)

[stryder09]

so saying that how should I change the wording? I truly am dense when it comes to this. so bare with me.

Brad

[pbaldy]

Got hung up when we had a power outage that took everything down. Did you get this sorted out? If not, what have you got so far?

[stryder09]

No I'm still trying to figure it out! Feeling very dense now! lol