How to calculate the average of columns

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Ilina Ivanova
    New Member
    • Oct 2010
    • 6
    #1

    How to calculate the average of columns

    I have a DB (Access 2007) with 4 columns. The first is the ID of the patient and the others are indexes PB1 , PB2, PB3. I have difficulties to calculate the average of columns PB1, PB2, PB3, because when 2 fields are filled the average needs to be divided by 2. Zero is a value too.
    Thanks!
    Last edited by Niheel; Oct 7 '10, 07:15 AM.
    Tags: None
    • Mariostg
      Contributor
      • Sep 2010
      • 332
      #2
      What do you mean by "When two fields are filled..."?
      You should provide more details, or exemple of data.

      By the way, why did you post the on the Postgresql forum while your DB is in MS Access?

        Comment

        Previous template Next
        Working...