Ilina Ivanova
Last Activity: Oct 18 '10, 12:48 PM
Joined: Oct 7 '10
Location: Bulgaria
-
Thank you, NeoPa! It`s really work! Thank you very, very much! It was so usefully joining the Bytes.com Expert Community! -
I have one table [Status] with four columns (ID, PB1, PB2, PB3) (the data in the other fields is not relevant to my question and I removed it). I want to create a query [Index] showing the ID in one column and the average of PB1,PB2,PB3 in second column. I have difficulties to build the expression for average because there are records with missing values and I need the sum to be divided by 2 or 1. Zero is a value too....Leave a comment:
-
Sorry NeoPa. I`ve tried many times including copy/paste after your recommendation but without any result. The expression disappears after I run the query or a message of incorrect subquery`s syntax appears.
Is it possible to e-mail you the file for help me.Leave a comment:
-
Thank you, NeoPa,
I`ve tried it, but it is impossible to run the query because of message „ ... the query does not include the specified expression „ID” as a part of an aggregate function”.
I am a beginner in Access and probably I make a mistake.Leave a comment:
-
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. -
How to calculate the average of columns
Please, help me!
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!
No activity results to display
Leave a comment: