Can You Exclude Amounts From a Sum Function on Report? 1

[lrdave36]

Hey guys,


I have an access report that contains a total field. The formula in the field is =SUM([PAB_AMOUNT]).

The problem is PAB_AMOUNT contains some amounts that I don't want included in the summery. These amounts occur on another table field called WAGE TYPE for wage types 9348 and 9349.

Is there any way I can add criteria excluding amounts on these wage types?

 

[PWise]

=sum(iif(wagetype not in(9348 ,9349), [PAB_AMOUNT] ,0)

 

[lrdave36]

That worked great. Thanks!