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))
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Count in a report 2
Adding Criteria to Access Reports 2
append query results in footer 1
Report and subreport w/Criteria Parameters issues 2
Counting with 2 Conditions 2
Can't calculate Grand Total of several other expressions 1
Sum in report 10

Back
Top