DCOUNT错误 [英] DCOUNT errors

问题描述

您好！我试图使用dcount来计算符合2个条件的查询中的记录。看起来像这样  = DCount（"识别"，"RecognitionEntryQry"，"EmployeeName = [Combo22] AND Recognition ='Teamwork'"）同样精确的
表达式适用于另一个数据库中的表但是没有查询。任何想法都会有所帮助。新访问，我看到有些人在字段中使用括号，但就像我说的，它适用于另一个带表的数据库。 

解决方案

1   ComboBox的BoundColumn是否与EmployeeName相对应？

2. 您是否在Combo22所在的表格上使用此DCount表达式？

 

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. 

解决方案

1.  Is the BoundColumn of the ComboBox corresponds to the EmployeeName?

2.  Are you using this DCount expression on the same Form that the Combo22 resides?

 

这篇关于DCOUNT错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！