adding up check marks for a report

  • Thread starter Thread starter Kay
  • Start date Start date
K

Kay

I currently have a field with a yes/no data type named "no
show". I would check this box on a form if the client
does not show up to the appointment. in a monthly report,
i would like to report the number of no shows for that
month, what do i need to do to get that value?
 
In the footer of the report add a text box and set its
control sourse to "=abs(sum([me.chkNoShow]))". Check boxes
store checks as -1 and no checks as 0. That is why you
have the absolute value function. Also a check box will
never be null. It is either a -1 or 0, true or false , yes
or no, all work the same in code.
 
Back
Top