本文介绍了DCOUNT错误的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
您好！我试图使用dcount来计算符合2个条件的查询中的记录。看起来像这样 = DCount（"识别"，"RecognitionEntryQry"，"EmployeeName = [Combo22] AND Recognition ='Teamwork'"）同样精确的
表达式适用于另一个数据库中的表但是没有查询。任何想法都会有所帮助。新访问，我看到有些人在字段中使用括号，但就像我说的，它适用于另一个带表的数据库。
解决方案
Hello! I am attempting to use dcount to count records in a query that match 2 criteria. It looks like this =DCount("Recognition","RecognitionEntryQry","EmployeeName=[Combo22] AND Recognition='Teamwork'") This same exact expression works with a table in another database but not with a query. Any ideas would help a bunch. New to access and I have seen some people use brackets for fields but like I said, it works in another DB with a table.
解决方案
这篇关于DCOUNT错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！