Count in a report

  • Thread starter Thread starter Benay
  • Start date Start date
B

Benay

I have a report based on a query that has the total as
the last field. The report has only Date and Total
fields. I am trying to count the number of instances
where Total > 33. Help!!
 
I have a report based on a query that has the total as
the last field. The report has only Date and Total
fields. I am trying to count the number of instances
where Total > 33. Help!!
Click to expand...

In the Report Footer section, add an unbound control.
Set it's control source to:
=Sum(IIf([Total]>33,1,0))
 
Thank you very, very, much. I appreciate your help.
-----Original Message-----
I have a report based on a query that has the total as
the last field. The report has only Date and Total
fields. I am trying to count the number of instances
where Total > 33. Help!!
Click to expand...

In the Report Footer section, add an unbound control.
Set it's control source to:
=Sum(IIf([Total]>33,1,0))
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top