Countif function on a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a field in the forms detail called cases. If I put a text field the footer and set the control source to = count(cases) then it counts the records in the detail.

How do I change this so that it only counts where cases is >0. Is there an equivalent countif function in access?

Bruce
 
Back
Top