DCount问题....再次

本文介绍了DCount问题....再次的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述 大家好。 我一直在使用Access一段时间，并试图多次使用DCount但结果各不相同。 我目前正在尝试以一种形式显示一个字段，该字段将显示已经输入特定地址的次数并在表格中有记录。所以我希望当用户输入地址时，DCount字段将显示已经输入表格的次数。以下代码用于无效 = DCount（Contamination2！Enq，Contamination2，Con tamination2！JoinedAddress = Forms！[Contaminated Inpu]！ [加入地址]"） 污染2 =表 污染2！Enq =要计数的字段（虽然我相信这可以更改为表中的任何字段？ ） 表格！[受污染的Inpu]！[加入地址] =我希望用作标准的表格上的文件。 感谢您的热切期待。 ....Hello everyoneI 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 = TableContamination2!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 | 行号 资本化不是考虑因素，因为以下所有4个表达式将在Northwind数据库中产生相同的结果，即5. ''all yield 5 展开 | 选择 | Wrap | 行号 这篇关于DCount问题....再次的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！