• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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,

0
dina78
Asked:
dina78
1 Solution
 
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

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now