Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Totaling a field for a report (Office 2000)

    I have a field in an access database that is asking if the customer is refusing counseling and has a checkmark box. I need to total the number of checks for the quartery report. Logically how is that expression build on the report form and does a query need to be created and how is that done. Thanks

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Totaling a field for a report (Office 2000)

    Let's say that the field is named "RefusesCounseling". I assume that it is a Yes/No field.

    Put a text box in the Report Footer section, and set its Control Source property to

    =Abs(Sum([RefusesCounseling]))

    This expression uses the fact that True = -1 and False = 0. If 8 customers refuse counseling, the sum of the field will be -8 (each check counts as -1), and by taking the absolute value we transform this into 8.

  3. #3
    New Lounger
    Join Date
    Jun 2003
    Location
    Camp Lejeune, North Carolina, USA
    Posts
    20
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Totaling a field for a report (Office 2000)

    Hans You are always a life saver. Thanks again

Posting Permissions

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