Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007
    Posts
    214

    Question Unanswered: Count if function reports

    Hello,

    I have a report and I need to tally the sum of certain data. I just don't know the exact function to use. Perhaps someone can help?

    I need a field in a report to display the following data.

    Sum or total of the "Won/Lost" field where "Won/Lost" = "Yes" and the "state" field = "PA"

    How would you compile this into a function? Would you use the count iif?

    Thanks!

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    depends entirely on how you have designed your schema
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2010
    Posts
    84
    Can you attach an example of your database?

Posting Permissions

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