Results 1 to 5 of 5
  1. #1
    Join Date
    May 2004
    Posts
    3

    Unanswered: Averaging without zeroes

    I am trying to average some values from an option group. The values range from zero to five. How do I calculate the average without including the zero?

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by yoggystyle
    I am trying to average some values from an option group. The values range from zero to five. How do I calculate the average without including the zero?
    What???? What are you trying to do?
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    May 2004
    Posts
    3

    Averaging without zeroes

    I have a form with several option groups on it. The option values assigned to each are 0,1,2,3,4 and 5.
    Each option group asks a question where the user will respond with 1-very low rating, 2-low rating, 3-ok rating, 4-good rating, 5-best rating or 0-N/A.
    I have a report that averages these values. However, I don't want to include the 0 value for the N/A responses. Is there anyway to average the responses from an option group without including the zeroes? Can I convert to Null values? Or am I attempting the impossible?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by yoggystyle
    I have a form with several option groups on it. The option values assigned to each are 0,1,2,3,4 and 5.
    Each option group asks a question where the user will respond with 1-very low rating, 2-low rating, 3-ok rating, 4-good rating, 5-best rating or 0-N/A.
    I have a report that averages these values. However, I don't want to include the 0 value for the N/A responses. Is there anyway to average the responses from an option group without including the zeroes? Can I convert to Null values? Or am I attempting the impossible?
    Ok ... Yes you can. Basically add your option values together and if you have a value of 0 don't increment your count ...
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    May 2004
    Posts
    3

    Averaging without zeroes

    Would you mind explaining a bit further for me? How do you go about not incrementing the count?

Posting Permissions

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