Access IIF Statement - If field is greater than other field by =/-percentage

L

lwestwell

Joined
Apr 4, 2017
Messages
1
Reaction score
0
Hello everyone,

I have the current formula

CompPassFail: IIf([specifiedComp]>[PCcomp],"Fail","Pass")

This works O.K, but I am being told that it should pass or fail if is within -/+3percent. Both field are percentage fields, where[specifiedComp]is the main number that [PCcomp] has to more or less align to.
 
Back
Top