DCount问题....再次 [英] DCount issues.... again

问题描述

大家好。


我一直在使用Access一段时间，并试图多次使用DCount但结果各不相同。


我目前正在尝试以一种形式显示一个字段，该字段将显示已经输入特定地址的次数并在表格中有记录。所以我希望当用户输入地址时，DCount字段将显示已经输入表格的次数。以下代码用于无效


= DCount（Contamination2！Enq，Contamination2，Con tamination2！JoinedAddress = Forms！[Contaminated Inpu]！ [加入地址]"）


污染2 =表

污染2！Enq =要计数的字段（虽然我相信这可以更改为表中的任何字段？ ）

表格！[受污染的Inpu]！[加入地址] =我希望用作标准的表格上的文件。


感谢您的热切期待。 ....

Hello everyone

I have been useing Access for a while now and have attempted useing DCount a number of times but with varying results.

I am currently trying to have a field in a form that will show how many times a particular address has been entered already and has a record in a table. So i was hoping that when the user enters an address the DCount field will show how many times it has already been entered into the table. The following code was used to to no avail

=DCount("Contamination2!Enq","Contamination2","Con tamination2!JoinedAddress=Forms![Contaminated Inpu]![joinedaddress]")

Contamination2 = Table
Contamination2!Enq = field to count (although i beleive this can change to any field in the table?)
Forms![Contaminated Inpu]![joinedaddress] = the filed on the form i want to use as the criteria.

Thanks in eager anticipation.....

推荐答案

展开 | 选择 | Wrap | 行号

谢谢你


我已经意识到这一点并且已经使用过各种功能，以确保尽可能多的一致性。例如所有大写字母。

Thanks for that

I have already realised this and have used various functions to ensure as much conformity as possible. all capital letters for example.

谢谢你


我已经意识到这一点和使用了各种功能来确保尽可能多的一致性。例如所有大写字母。

Thanks for that

I have already realised this and have used various functions to ensure as much conformity as possible. all capital letters for example.

资本化不是考虑因素，因为以下所有4个表达式将在Northwind数据库中产生相同的结果，即5.

''all yield 5

展开 | 选择 | Wrap | < span class =codeLinkonclick =LineNumbers（this）;>行号

这篇关于DCount问题....再次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！