SQL / Access（平均代码） [英] SQL / Access (Average Code)

问题描述

目前正在运行带有Access作为前端的SQL Server 2005。我想在一个表中得到5个独立字段的数字平均值。 （不包括NULL字段）。我想在Access中的学术部门视图中显示平均值。我不能为生命决定是否最好在SQL中的某种视图中或在VB端的Access中完成。我也无法找到用于处理此数据的基本代码。任何帮助将不胜感激，谢谢！

Currently running SQL Server 2005 with Access as the frontend. I''m trying to get the numerical average of 5 separate fields within one table. (Excluding NULL fields). I would like to display the average on the form our academics department views in Access. I cannot for the life me decide on if this would be best accomplished in some sort of view in SQL or just in Access on the VB side. I also was having trouble finding the basic code I would use to process this data. Any help would be greatly appreciated, thanks!

推荐答案

您是否想要获得单行中五个字段的平均值？


- CK

Are you trying to get the average of the five fields in a single row?

-- CK

是 - 至少每个学生记录。

Yes - At least for each student record.

到目前为止你有什么？


--- CK

What do you have so far?

--- CK

这篇关于SQL / Access（平均代码）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！