Re: Count records in a report

Since checkboxes are usually tied to a yes/no field they always have a
value. The trick here is to account for the field always having a value (-1
or 0).

=Abs(Sum(CheckboxField))

or

= Count(IIF(CheckboxField=True,1, Null))



--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

"Angela" <Angela@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:186ECD19-969C-488D-BADC-30AB58158046@xxxxxxxxxxxxxxxx
Is there a function in Access that would enable me to count the records in
a
Report when a check box is ticked


.

Relevant Pages

  • check box into a text field on a report
    ... i have a table with 12 checkboxes for different type of products, ... basically user has to tick if this product applies to the entered ... account. ... i have the same group of boxes in my report which i want ...
    (comp.databases.ms-access)
  • Re: check box into a text field on a report
    ... account. ... i have the same group of boxes in my report which i want ... I'd probably drag all 12 checkboxes to the report and set their visible ...
    (comp.databases.ms-access)
  • Re: Redemption, Help with selecting E-mail Account
    ... Using the x-header trick or using RDOMail.Account are roughly equivalent. ... [MVP - Outlook] ... Is there any way I can select an account to be used for sending a ... its value as the value of the header. ...
    (microsoft.public.outlook.program_vba)
  • Re: New MS Security Phish
    ... Just for the record this is not a "phishing" attempt it is an attempt to ... trick you into running malware. ... PayPal account, and multiple password failures were present before the ...
    (microsoft.public.security)
  • Re: Administrator change
    ... David's suggestion finally did the trick and got rid of 'David' as it ... Run through the restore again. ... into it, and then go to Control Panel, Users, and delete the old account. ...
    (microsoft.public.windowsxp.help_and_support)