Need help on average function in Query

[simpatiko]

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

 

[ajetrumpet]

access queries are NOT for calculating horizontally. if you want to set up data this way, use excel.

 

[Brianwarnock]

Lookup the NZ function

 

[Rich]

How are you going to calculate the correct average when some columns have no data?

 

[wilpeter]

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.