Count in a report

A

APH

Hi
In a report I have a field [criteria] and a field [total]
I want to sum the value of [total] where [criteria] <> "Response"
is this possible please?

Thanks

Alex
 
F

Fredg

In an unbound control in the Report's Detail section,
or in the Report Footer:

=Sum(IIf([Criteria] <> "Response",[Total],0))
 
Top