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屋！
