Count in a report

  • Thread starter Thread starter APH
  • Start date Start date
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
 
In an unbound control in the Report's Detail section,
or in the Report Footer:

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