<>=

[blancla]

I created this expression from other 2 expressions
Expr3: IIf([Expr1]>[Expr2],"MISS","HIT")

Expr1 is a variance from Field1 and Field2
Expr2 is Field2 x 2%
Expr3 should be a "HIT" if Expr1 is < Expr2

or = should be a "MISS"

but when I have a large negative qty is making it a "HIT" when it should
really be a "MISS"

 

[KARL DEWEY]

[Expr1] and [Expr2] are aliases create in the query. Do not use them in the
same query as you may be trying to use them BEFORE they are created.
Use their calculations like this --
Expr3: IIf((Whatever Expr1 is composed of)>(Field2 x .02),"MISS","HIT")

--
KARL DEWEY
Build a little - Test a little

I created this expression from other 2 expressions
Expr3: IIf([Expr1]>[Expr2],"MISS","HIT")

Expr1 is a variance from Field1 and Field2
Expr2 is Field2 x 2%
Expr3 should be a "HIT" if Expr1 is < Expr2

or = should be a "MISS"

but when I have a large negative qty is making it a "HIT" when it should
really be a "MISS"