Finding the average of a set of data

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,

dina78Asked:
Who is Participating?
 
Rey Obrero (Capricorn1)Commented:
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
 
dina78Author Commented:
worked like a charm,, thanks alot
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.