Need help on average function in Query

simpatiko

New member
Local time
Yesterday, 22:09
Joined
Feb 27, 2010
Messages
1
This as an example of i want to do please do help.


Name-----Grade1----Grade2----Grade3 ------- Average

Kevin---------80 -------80 ------80----------- 80

Dave---------78----No entry ----3------------- Only computes Average in Grade 1&3

Peter --------A------- B---------A------------- Can manually enter values in all columns even in calculated column


Thanks
 
access queries are NOT for calculating horizontally. if you want to set up data this way, use excel.
 
Lookup the NZ function
 
How are you going to calculate the correct average when some columns have no data?
 
Simpatiko: Also, if the three GradeX fields are Text (in order to allow the ABC), the numbers would be tricky to average in Access. Try exporting to Excel using Tools, Office Links, Analyze.
 

Users who are viewing this thread

Back
Top Bottom