Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2002
    Location
    The Netherlands
    Posts
    3

    Unhappy Unanswered: Count in reports

    Hi,

    I want to count records in a report. But this doesn't work at all.

    For example
    Name P1 P2 P3 P4 MB
    Sander 1 2 3 0 0
    Peter 2 4 6 1 0
    Jaap 3 8 0 0 0
    Dennis 0 0 0 0 -1

    (MB is a Yes/No option on a form)

    First I want to know how much records every collumm has unless it's 0.
    Like this:
    Total 3 3 2 1 1

    And then i want tot know the average:
    average 2 4,6 4,5 1 -

    Can somebody help me!!

    Greetings,
    Sander

  2. #2
    Join Date
    Aug 2002
    Location
    Québec, Canada
    Posts
    109
    Insert a TextBox in you Report Footer and make the formulas as follow: "=SUM(P1)". Use "=AVG(P1)" to know the average of the field

    JefB

Posting Permissions

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