Dsum问题 [英] Dsum Issue
问题描述
您好,
感谢前任帮手,我在这里找到了一些很棒的Dsum信息:
http://www.mvps.org/access/general/gen0018.htm
>
不幸的是,我无法获得符合我要求的代码。
我想把我收到的付款($)字段汇总到我的''每个具有字段付款方式的记录的tbl_treatment payment''表=现金。
我正在使用的代码是:
= DSum(收到付款,tbl_treatment付款和,付款方式=现金)
我确定我的错误很简单,但我不能为我的生活弄清楚。它让我发疯了。
这就是Access 2000中的报告。
谢谢!
Hello,
Thanks to a previous helper I found some great Dsum info here:
http://www.mvps.org/access/general/gen0018.htm
Unfortunately I can''t get the code to work for my requirements.
I''m trying to sum the payment received ($) field within my ''tbl_treatment payments'' table for every record that has the field "payment method" = cash.
The code I''m using is:
=DSum("payment received","tbl_treatment payments","payment method = cash")
I''m sure my mistake is something simple, however I can''t for the life of me figure it out. It''s driving me crazy.
This is all for a report in Access 2000.
Thanks!
推荐答案
字段=现金。
我正在使用的代码是:
= DSum(收到付款,tbl_treatment付款和,付款方式=现金)
我确定我的错误很简单,但我不能为我的生活弄清楚。它让我发疯了。
这就是Access 2000中的一个报告。
谢谢!
) field within my ''tbl_treatment payments'' table for every record that has the field "payment method" = cash.
The code I''m using is:
=DSum("payment received","tbl_treatment payments","payment method = cash")
I''m sure my mistake is something simple, however I can''t for the life of me figure it out. It''s driving me crazy.
This is all for a report in Access 2000.
Thanks!
您好,
感谢先前的帮助,我在这里找到了一些很棒的Dsum信息:
http://www.mvps.org/access/general/ gen0018.htm
很遗憾,我无法获得满足我要求的代码。
我是试图在我的'tbl_treatment付款'表中为每个具有字段付款方式字段的记录汇总收到的付款(
Hello,
Thanks to a previous helper I found some great Dsum info here:
http://www.mvps.org/access/general/gen0018.htm
Unfortunately I can''t get the code to work for my requirements.
I''m trying to sum the payment received (
)字段。 =现金。
我正在使用的代码是:
我确定我的错误很简单,但我可以我为你的生活弄清楚了。它让我发疯了。
这就是Access 2000中的报告。
谢谢!
) field within my ''tbl_treatment payments'' table for every record that has the field "payment method" = cash.
The code I''m using is:
I''m sure my mistake is something simple, however I can''t for the life of me figure it out. It''s driving me crazy.
This is all for a report in Access 2000.
Thanks!
嗨
看看上面提到的网站,我建议你看看给出的第二行
对于数值:
DLookup(FieldName,TableName,Criteria = n)
对于字符串:(注意值前后的撇号)
DLookup(" FieldName"," TableName"," Criteria =''string''")
日期:
DLookup(FieldName,TableName,Criteria =#date#)
基于现金是一个文本字段?
MTB
Hi
Looking at the site you references above, I suggest you look at the second line given
For numerical values:
DLookup("FieldName" , "TableName" , "Criteria = n")
For strings: (note the apostrophe before and after the value)
DLookup("FieldName" , "TableName" , "Criteria= ''string''")
For dates:
DLookup("FieldName" , "TableName" , "Criteria= #date#")
on the basis that ''cash'' is a text field ??
MTB
这篇关于Dsum问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!