Improve company productivity with a Business Account.Sign Up

x
?
Solved

Finding the average of a set of data

Posted on 2008-10-14
2
Medium Priority
?
265 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 2000 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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.

Join & Write a Comment

MSSQL DB-maintenance also needs implementation of multiple activities. However, unprecedented errors can hamper the database management. In that case, deploying Stellar SQL Database Toolkit ensures fast and accurate database and backup repair as wel…
A quick solution showing how to control and open a POS Cash Register Drawer using VBA with MS Access.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

606 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