在报告中过滤COUNTS [英] Filter COUNTS in a report

问题描述

我有一个基于查询的报告，在报告中我有三列


Column1

=总和（Abs（[qryMonthlyReport]！[ ClearanceCode]喜欢*））


Column2

=总和（Abs（[qryMonthlyReport]！[ClearanceCode] =" O"））


Column3

=总和（Abs（[qryMonthlyReport]！[ClearanceCode]<>" O"）

我的问题是我还想根据日期范围限制列，例如：

[Forms]之间！[frmMonthlyReport]！[Date1]和[Forms] ！[frmMonthlyReport]！[Date2]


我无法弄清楚我一直收到错误的正确方法。

谢谢

I have a report based on a query, in the report I have three columns

Column1
=Sum(Abs([qryMonthlyReport]![ClearanceCode] Like "*"))

Column2
=Sum(Abs([qryMonthlyReport]![ClearanceCode]="O"))

Column3
=Sum(Abs([qryMonthlyReport]![ClearanceCode]<>"O"))

My problem is I also want to limit the columns based on a date range in a form such as:
Between [Forms]![frmMonthlyReport]![Date1] And [Forms]![frmMonthlyReport]![Date2]

I just can''t figure out the correct way I keep getting errors.
Thanks

推荐答案

首先，我不知道你在这里使用Abs（）函数是什么，因为它需要一个数字，你的字段似乎包含文本。此外，如果您在报表上引用此类字段，则应将报表上的字段作为控件单独使用。如果你不希望看到它，你可以使它隐身。

Firstly, I''m not sure what you are using the Abs() function for here as it requires a number and your field seems to contain text. Also if you are referencing a field like this on a report you should have the field on the report as a control on its own. You can make it invisible if you do not wish to see it.

首先，我不确定你使用的是什么这里的Abs（）函数需要一个数字，而你的字段似乎包含文本。此外，如果您在报表上引用此类字段，则应将报表上的字段作为控件单独使用。如果您不希望看到它，可以使其隐藏。

Firstly, I''m not sure what you are using the Abs() function for here as it requires a number and your field seems to contain text. Also if you are referencing a field like this on a report you should have the field on the report as a control on its own. You can make it invisible if you do not wish to see it.

好​​的，但我如何根据我发布的信息做到这一点？我可以提供哪些其他信息来帮助您？


谢谢

Ok but how do I do this based on the information I posted? What other information can I provide to help you help me?

Thanks

为什么使用Abs功能。你想要实现什么目标？

Why are you using the Abs function. What are you trying to achieve?

这篇关于在报告中过滤COUNTS的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！