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))
 

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

How to display zero value in blank fields of Cross Tab query 0
Count in a report 2
A03 - count in report footer gives me #Error? 0
Adding Criteria to Access Reports 2
Weekly Report 2
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
How to automate update on weekly reports spreadsheet 0
SUM of COUNT? 8

Top