By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,960 Members | 987 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,960 IT Pros & Developers. It's quick & easy.

How to calculate the average of columns

P: 6
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!
Oct 7 '10 #1
Share this Question
Share on Google+
1 Reply


100+
P: 332
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?
Oct 7 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.