从子表单中获取总和 [英] Getting the sum from a subform

问题描述

我试图从子表单中获取一个总和以显示在计算的控件中。目前，我正在使用这个表达式：

= [RentalUnit子表单]。[表单]！[NumOfRes]

但是当我查看我的表单时，它只显示2个占用者反对预期的12。如何获得要显示的NumOfRes的总和？


谢谢！

I am trying to get a sum from a subform to show within a calculated control. Currently, I am using this expression:
=[RentalUnit subform].[Form]![NumOfRes]
But when I view my form, it shows only 2 occupants as opposed to the 12 that is expected. How do I get the sum of the NumOfRes to display?

Thanks!

推荐答案

我试图从子表单中获取一个总和以显示在计算控件中。目前，我正在使用这个表达式：

= [RentalUnit子表单]。[表单]！[NumOfRes]

但是当我查看我的表单时，它只显示2个占用者反对预期的12。如何显示NumOfRes的总和？


谢谢！

I am trying to get a sum from a subform to show within a calculated control. Currently, I am using this expression:
=[RentalUnit subform].[Form]![NumOfRes]
But when I view my form, it shows only 2 occupants as opposed to the 12 that is expected. How do I get the sum of the NumOfRes to display?

Thanks!

''这是我用来计算库存中特定Item_ID

''的子表单中的值的代码。这是一个计算控件，存在于父窗体中，对于计算控件的

''控件源属性。

''Here is code that I use to calculate values in a Sub-Form for a specific Item_ID
''in Inventory. This is a Calculated Control that exists in the Parent Form, For the
''Control Source Property of the Calculated Control.

展开 | 选择 | Wrap | 行号

''这是我用来计算特定Item_ID的子表单中的值的代码

''在库存中。这是一个计算控件，存在于父窗体中，对于计算控件的

''控件源属性。

''Here is code that I use to calculate values in a Sub-Form for a specific Item_ID
''in Inventory. This is a Calculated Control that exists in the Parent Form, For the
''Control Source Property of the Calculated Control.

展开 | 选择 | Wrap | 行号

ADezii，


我遇到了同样的问题。我不明白你上面的代码。什么是tblLocSubLocQty？

ADezii,

I had the same problem. I don''t understand your code above. What is "tblLocSubLocQty"?

存储各种库存值的表

A Table that stores various Inventory values

这篇关于从子表单中获取总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！