Thread: =
View Single Post
  #1  
Old July 10th, 2008, 05:10 PM posted to microsoft.public.access.queries
blancla
external usenet poster
 
Posts: 2
Default =

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"