Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    21

    Angry Unanswered: Counting and Totals

    I know it has been awhile since I have done this but it can't be this difficult. I have a report that I am creating that I need to run totals on. The report is grouped by product and each product has request for add, deletes, and maintenance. I have these set as yes/ no check boxes. What I need to do is the number of add, deletes, etc per group and then a final total. If I do a count in the query it counts each box not just the yeses. If I do a running sum it gives me a -1. Below is an example of the data.

    BIA
    12-1 Add
    12-2 Delete
    11/28 Delete
    11/4 Maintenance

    If I total these I should get 1 Add, 2 deletes, and 1 maintenance for product BIA.

    Help please. Hope this makes sense. You can email me at drbaker@ftb.com if you need more info. THANKS.

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    This is easy ...

    Put a textbox in a footer (report, group, page, or otherwise ...) Set the ControlSource to:

    =Sum(IIf([YesNoField]=True,1,0))

    Set this up for each of the request types ...

  3. #3
    Join Date
    Dec 2003
    Posts
    21

    Thumbs up

    Works perfect Thanks!!!!!!!!!!!!!!!!!!!!!!!!!

Posting Permissions

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