尝试在报告中总计一个文本框 [英] Trying to total a text box in report
问题描述
可以使用一些帮助。我不知道我是否能做我正在努力的事情。我在详细信息部分下的报告中有一个文本框。它会为
返回特定记录集上每一行的值。可能有1行/ b $ b行或10行。我想要做的是将该文本框中的总数相加。
我尝试将以下代码放在控件源中。它不会像它那样b $ b。我不知道我是不是只是错误地填写它或者它是否b / b
将会起作用。感谢您的帮助。
DSum([SITE TOT],[表格]![露营收据]!,<>)
2005年12月16日05:07:14 -0800,deercreek < da*@deercreekcg.com>
写道:
在sum字段的控制源中尝试这个:
=总和([SITE TOT])
-Tom。
可以使用一些帮助。我不知道我是否能做我正在做的事情。我在详细信息部分下的报告中有一个文本框。它将为特定记录集上的每一行返回一个值。可能有1行或10行。我想要做的是将该文本框中的总数相加。
我尝试将以下代码放在控件源中。它不喜欢它。我不知道我是不是错误地填写它或者它是否会起作用。感谢您的帮助。
DSum([SITE TOT],[Forms]![Camping Receipt]!,<>)
是的,我已经尝试过它也不能正常工作。
你需要确保包含公式=总和([SITE
TOT])位于组,页面或报表页脚中。
Could use some help. I don''t know if I can even do whatI''m trying to
do. I have a text box in a report under the details section. It will
return a value for each line on a sepcific record set. There may be 1
line or 10 lines. What I want to do is sum the totals in that text box.
I tried putting the following code in the control source. It dosn''t
like it. I don''t know if I''m just putiing it in incorrectly or if it
will work at all. Thanks for any help.
DSum ( [SITE TOT] , [Forms]![Camping Receipt]!, <>)
On 16 Dec 2005 05:07:14 -0800, "deercreek" <da*@deercreekcg.com>
wrote:
Try this in the control source for the sum field:
=Sum([SITE TOT])
-Tom.
Could use some help. I don''t know if I can even do whatI''m trying to
do. I have a text box in a report under the details section. It will
return a value for each line on a sepcific record set. There may be 1
line or 10 lines. What I want to do is sum the totals in that text box.
I tried putting the following code in the control source. It dosn''t
like it. I don''t know if I''m just putiing it in incorrectly or if it
will work at all. Thanks for any help.
DSum ( [SITE TOT] , [Forms]![Camping Receipt]!, <>)
Yea I already tried that it dosn''t work either.
You need to make sure the textbox that contains the formula =Sum([SITE
TOT]) is in a group, page, or report footer.
这篇关于尝试在报告中总计一个文本框的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!