Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Apr 2014
    Posts
    18
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Count Text Box on Report

    I am having a brain cramp. Maybe because it is a Friday.
    I have a text box on a report that counts the number of records on the report (=Count[Name]). No problem there. I have a second box that I want to add that will also count the records but I only want it to count the number of records that have a check mark(yes) in a yes/no box on the report. The problem with that box is that there will be reports with no boxes checked so I need a type of NZ = 0 type code to go with the iif or countif function. The field name is [Student]. Any suggestions?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,519
    Thanks
    3
    Thanked 50 Times in 50 Posts
    The usual solution for this issue is to do a Sum() of the field with the check mark - the True conditions will be a -1 so you then have to take the ABS() function and convert it to a positive number. The one worry is if your back-end is a table in Access, then binary fields can have a null condition - we usually work around that by forcing the field to be either True or False by not allowing nulls.
    Wendell

  3. #3
    New Lounger
    Join Date
    Apr 2014
    Posts
    18
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thank You for taking the time to respond.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •