MS Access splitview totalrow不会求和 [英] MS Access splitview totalrow will not sum

问题描述

我有一个在splitview中显示的访问表单。后面的查询有几个计算字段以及几个别名表及其字段。货币字段将在除总和之外的每个运算符的总行中起作用。当选择下降
下降，计数，平均等...工作，但总和不工作。

 

解决方案

你有空值吗？ （Nulls） 

如果是这样，你要添加一个数字为Null = Null

将Null转换为零：NZ（MyNo，0）

I have an access form that displays in splitview. The query behind has several calculated fields as well as several aliased tables and their fields. The Currency fields will work in the total row with every operator except the sum. When choosing the drop down, count, average, etc... work, but sum does not.

 

解决方案

Do you have any blank values? (Nulls) 

If so you are adding a number to Null = Null

Convert Null to Zero with: NZ(MyNo,0)

这篇关于MS Access splitview totalrow不会求和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！