报告中的可怕DCOUNT函数 [英] The Dreaded DCOUNT Function in a Report
问题描述
下午好，
我试图只计算报告中的记录，这些记录基于查询，其中Status等于Closed。我尝试了多种DCOUNT变体，但我不断收到#ERROR。报告中控件源框中的消息。下面是我试图多次使用和修改的表达式。不知道我是否仅仅是语法问题，或者我的公式是错误的。我确实尝试使用建议的SQL语句，该语句也在下面，但我不知道如何将我的报告中嵌入的SQL语句的结果。任何意见是极大的赞赏。谢谢！
我建议的陈述：
Good afternoon,
I am attempting to count only those records within a report, which is based on a query, where Status is equal to Closed. I have tried multiple variations of DCOUNT but am continuously receiving the "#ERROR" message in the control source box on the report. Below is the expression that I have tried to use and modify numerous times. Don''t know if i''m just simply having syntax issues or my formula is just wrong. I did attempt to use a suggested SQL statement which is also below but I don''t know how to get the result of that SQL statement embedded in my Report. Any advice is greatly appreciated. THANKS!
My proposed statement:
推荐答案
欢迎对于TheScripts。
SQL在查询名称中嵌入了空格而没有[]分隔符。
数据集的名称在SQL和&之间有所不同。表达式。
尝试解决这些问题并查看它的位置。
Welcome to TheScripts.
The SQL has embedded spaces in the query name without the [] delimiters.
The name of the dataset differs between the SQL & the expression.
Try resolving these issues and seeing where that gets you.
下午好，
我试图只计算报告中的记录，这些记录基于查询，其中Status等于Closed。我尝试了多种DCOUNT变体，但我不断收到#ERROR。报告中控件源框中的消息。下面是我试图多次使用和修改的表达式。不知道我是否仅仅是语法问题，或者我的公式是错误的。我确实尝试使用建议的SQL语句，该语句也在下面，但我不知道如何将我的报告中嵌入的SQL语句的结果。任何意见是极大的赞赏。谢谢！
我建议的陈述：
Good afternoon,
I am attempting to count only those records within a report, which is based on a query, where Status is equal to Closed. I have tried multiple variations of DCOUNT but am continuously receiving the "#ERROR" message in the control source box on the report. Below is the expression that I have tried to use and modify numerous times. Don''t know if i''m just simply having syntax issues or my formula is just wrong. I did attempt to use a suggested SQL statement which is also below but I don''t know how to get the result of that SQL statement embedded in my Report. Any advice is greatly appreciated. THANKS!
My proposed statement:
感谢您的快速帮助。你是对的，他们是不同的。我一直在做反复试验。相当多，忘了将SQL语句更改回使用查询。如果我确实已经通过格式化确定了下面的内容，我的目标实际上只是使用一种方法将总数放在完成的报告上。是否使用嵌入式SQL语句，我不确定如何在报告中嵌入语句，或者使用Dcount。选项作为带有文本框的控件源。当然，在这一点上，两个都不适合我......哈！他们现在怎么样？谢谢你的协助。
Thanks for your quick assistance. And you''re right, they were different. I have been doing "trial and error" quite a bit and forgot to change the SQL statement back to using the query. If I indeed have the below now corrected with formatting, my goal is really to only use one means of putting the total on the finished report. Whether it be using the embedded SQL statement, which I''m not sure how to even embedd the statement within a report, or use the "Dcount" option as a control source with a text box. Of course at this point neither is working for me...HA! How does they look now? Thanks for your assistance.
这篇关于报告中的可怕DCOUNT函数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
