calculation in a report

F

Fipp

In my "stats" report I am trying to calculate the count
of the yes/no field "turnin" of those records where the
value = yes.

I am sure there is an easy expression or function but I
can't figure it out. Any help is greatly appreciated.

Fipp
 
A

Allen Browne

Try a control source of:
= - Sum([turnin])

True is -1. False is 0. Sum the field. Negate the result.
 

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

Weekly Report 2
Calculation Based on Dynamic Variables (What-if Scenario) 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Access 2002 change report header text 0
Help with Iif on Report 4
averaging a field value if field value is greater then 0 access report 4
syntax for count text field 4
Combining SUM and IIF NULL Statement 5

Top