I have the following expression in a Query and for some reason its giving me correct results for the part of the expression of [AMOUNT] but it is not calculating [TRANSTYPE] ="Cash-In" the end result shows Cash-In and also Cash-Out.. When It should only give me Cash-In transactions. Is the expression build correctly?
In a nut shell the expression below should give me a count of [AMOUNT] that are between 0.00 and 10,000 and that their [TRANSTYPE] is only equal to Cash-In. Any help would be appreciated..
Range_0_10: Count((((IIf([AMOUNT]<=10000 And [AMOUNT]>0 And [TRANSTYPE]="Cash-In",1,0)))))
In a nut shell the expression below should give me a count of [AMOUNT] that are between 0.00 and 10,000 and that their [TRANSTYPE] is only equal to Cash-In. Any help would be appreciated..
Range_0_10: Count((((IIf([AMOUNT]<=10000 And [AMOUNT]>0 And [TRANSTYPE]="Cash-In",1,0)))))
