Solved

Finding the average of a set of data

Posted on 2008-10-14
2
217 Views
Last Modified: 2010-04-21
Hello Experts,

In access what is the equivalent of the DAAVERAGE function in excel?
Or In another world how can I calculate the average of 3 columns if I have a null value in some of the cells without affecting my average accuracy ?
Regards,

0
Comment
Question by:dina78
2 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 22710490
try this query

select A.id, avg([x]) as averagevalue
from
(
select id, colA as x from table1
union all
select id, colB  from table1
union all
select id, colC from table1
) as A
group by A.id
0
 

Author Closing Comment

by:dina78
ID: 31505840
worked like a charm,, thanks alot
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question