子表单和SUM [英] subform and SUM

问题描述

你好，


任何帮助都将不胜感激!!!


我需要在符合某一特定条件的收据子表格上加上AMOUNTTEND标准。


必须是这样的。


= sum（[amounttend]）其中[description] =" tour installment"


换句话说，我只想在描述字段中总计金额

=" tour installment"


任何人都可以帮助正确的语法吗？


谢谢，


戴夫

解决方案

2007年11月3日星期六01:54:45 GMT，David Grist < di ***** @ verizon.net>

写道：


在帮助文件中查看DSum。

-Tom。

>您好，

任何帮助将不胜感激!!!

我需要在符合特定标准的收据子表单上总计AMOUNTTEND。

它必须类似于。

= sum（[amounttend]）其中[description] ="游览分期付款

换句话说，我想在描述字段中仅总计金额
=游览分期付款

任何人都可以帮助正确语法？

谢谢，

Dave

我查了一下dsum，但这是对整体的总结表格。

Tom van Stiphout < no ************* @ cox.netwrote in message

news：r8 ***************** *************** @ 4ax.com ...

2007年11月3日星期六01:54:45 GMT ，大卫·格里斯特， < di ***** @ verizon.net>

写道：


在帮助文件中查看DSum。

-Tom。

>>您好，

任何帮助将不胜感激!!!

我需要在符合某个
标准的收据子表单上加上AMOUNTTEND。

它必须是类似的东西。

= sum（[amounttend]）其中[说明] =游览分期付款

换句话说，我想只在描述时总计金额
=
=" tour installment"

任何人都可以帮助正确的语法吗？

谢谢，

尝试


=总和（IIf（[描述] ="旅行安装，[金额]，0）


hth

David Grist"< di ***** @ verizon.netwrote in message

news：FxQWi.71

Hello,

Any help would be appreciated!!!

I need to sum AMOUNTTEND on a receipts subform that meet a certain criteria.

It has to be something like.

=sum([amounttend]) where [description]="tour installment"

in other words, I want to total only the amounts when the description field
= "tour installment"

Can anyone help with the correct syntax?

Thanks,

Dave

解决方案

On Sat, 03 Nov 2007 01:54:45 GMT, "David Grist" <di*****@verizon.net>
wrote:

Check out DSum in the help file.
-Tom.

>Hello,

Any help would be appreciated!!!

I need to sum AMOUNTTEND on a receipts subform that meet a certain criteria.

It has to be something like.

=sum([amounttend]) where [description]="tour installment"

in other words, I want to total only the amounts when the description field
= "tour installment"

Can anyone help with the correct syntax?

Thanks,

Dave

I checked out dsum but that is summing the whole table.
"Tom van Stiphout" <no*************@cox.netwrote in message
news:r8********************************@4ax.com...

On Sat, 03 Nov 2007 01:54:45 GMT, "David Grist" <di*****@verizon.net>
wrote:

Check out DSum in the help file.
-Tom.

>>Hello,

Any help would be appreciated!!!

I need to sum AMOUNTTEND on a receipts subform that meet a certain
criteria.

It has to be something like.

=sum([amounttend]) where [description]="tour installment"

in other words, I want to total only the amounts when the description
field
= "tour installment"

Can anyone help with the correct syntax?

Thanks,

Dave

try

=Sum(IIf([description]="tour installment",[amounttend],0)

hth
"David Grist" <di*****@verizon.netwrote in message
news:FxQWi.71

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