拼命寻求帮助过滤动态交叉表查询报告 [英] Desperately Seeking Help Filtering a Dynamic Crosstab Query Report

问题描述

我试图在1月14日之前提出这个问题，但我从未收到过

回复。我还在努力解决这个问题。我会尝试改写

问题：


我有一个交叉表查询，包含学生行和活动列，以及

数据是学生在每项活动中的得分。没问题，差不多。

问题是目前有五个班级，未来学期将有更多的课程（或课程）。我不希望所有的课程都显示在同一份报告上。我可以过滤查询，但报告不会让b $ b识别过滤后的查询。我可以发布整个代码，但报告中的过滤器

看起来像这样：

DoCmd.ApplyFilter，Me.courseCode ='' " &

Forms！frmSelectCourse！cboSelectCourse& "''"


或者，在我的查询的过滤版本中，我的情况如下：


.... WHERE

（（（studentsInCourses.courseCode）= [表格]！[frmSelectCourse]！[cboSelectCourse]

））


这个WHERE条件在查询中工作正常，但我的报告不喜欢它。

报告在我的查询的未过滤版本中工作正常，但它显示

每个class，因此创建了空列。


在所有的例子中我都看到了动态交叉表查询报告遍布

web我从来没有看到一个被过滤了。难道这种类型的b
报告不喜欢过滤吗？任何想法？


非常感谢提前，


Rich Hollenbeck

I tried to ask this question before on the 14th of January but I never got a
reply. I''m still struggling with the problem. I''ll try to rephrase the
question:

I have a crosstab query with rows of students and columns of activities and
the data are the students'' scores in each activity. No problem, almost.
The problem is that there are five classes at the moment and will be more
classes (or courses) in future semesters. I don''t want all the classes to
show up on the same report. I can filter the query but the report won''t
recognize the filtered query. I could post the entire code, but the filter
inside the report would look like this:

DoCmd.ApplyFilter , "Me.courseCode = ''" &
Forms!frmSelectCourse!cboSelectCourse & "''"

or, in the filtered version of my query, my condition looks like this:

....WHERE
(((studentsInCourses.courseCode)=[Forms]![frmSelectCourse]![cboSelectCourse]
))

This WHERE condition works fine in the query but my report doesn''t like it.
The report works fine in the unfiltered version of my query, but it shows
every class, thus creating empty columns.

In all the examples I''ve seen of dynamic crosstab query reports all over the
web I''ve never seen one that was filtered. Could it be that this type of
report just doesn''t like filtering? Any ideas?

Many thanks in advance,

Rich Hollenbeck

推荐答案

交叉表查询显式参数。

在设计视图中打开查询，然后单击查询 - 参数。

在弹出的对话框中，输入

表格！frmSelectCourse！cboSelectCourse

在左侧，并指定右侧的数据类型。


HTH

" Richard Hollenbeck" < RI **************** @ verizon.net>在消息中写道

news：o5XTd.18050

Crosstab queries like explicit parameters.
Open your query in design view, then click Query - Parameters.
In the dialog box that pops up, put
Forms!frmSelectCourse!cboSelectCourse
on the left side, and specify the data type on the right.

HTH

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message
news:o5XTd.18050

uc.2699@trnddc09 ...

uc.2699@trnddc09...

我之前试过问这个问题在1月14日但我没有得到
a回复。我还在努力解决这个问题。我会尝试重新解释
问题：

我有一个交叉表查询，包含学生行和活动列
，数据是每个学生的分数活动。几乎没问题。
问题在于，目前有五门课程，未来学期将有更多的课程（或课程）。我不希望所有的课程都出现在同一份报告上。我可以过滤查询，但报告不会识别过滤后的查询。我可以发布整个代码，但报告中的
过滤器看起来像这样：

DoCmd.ApplyFilter，Me.courseCode =''" &
形式！frmSelectCourse！cboSelectCourse& 或，或者，在我的查询的过滤版本中，我的情况如下：

... WHERE

（（（studentsInCourses.courseCode）= [Forms]！[frmSelectCourse]！[cboSelectCourse]））

这个WHERE条件在查询中工作正常但我的报告不喜欢
it 。该报告在我的查询的未过滤版本中运行良好，但它显示了每个类，因此创建了空列。

在我看到的动态交叉表查询报告的所有示例中超过
网络我从未见过过滤过的网站。可能是这种类型的报告只是不喜欢过滤？有什么想法吗？

非常感谢提前，

Rich Hollenbeck

I tried to ask this question before on the 14th of January but I never got a reply. I''m still struggling with the problem. I''ll try to rephrase the
question:

I have a crosstab query with rows of students and columns of activities and the data are the students'' scores in each activity. No problem, almost.
The problem is that there are five classes at the moment and will be more
classes (or courses) in future semesters. I don''t want all the classes to
show up on the same report. I can filter the query but the report won''t
recognize the filtered query. I could post the entire code, but the filter inside the report would look like this:

DoCmd.ApplyFilter , "Me.courseCode = ''" &
Forms!frmSelectCourse!cboSelectCourse & "''"

or, in the filtered version of my query, my condition looks like this:

...WHERE
(((studentsInCourses.courseCode)=[Forms]![frmSelectCourse]![cboSelectCourse] ))

This WHERE condition works fine in the query but my report doesn''t like it. The report works fine in the unfiltered version of my query, but it shows
every class, thus creating empty columns.

In all the examples I''ve seen of dynamic crosstab query reports all over the web I''ve never seen one that was filtered. Could it be that this type of
report just doesn''t like filtering? Any ideas?

Many thanks in advance,

Rich Hollenbeck

（回复移至底部发布（见下文））

(replies moved to bottom-posting (see below))

" Richard Hollenbeck" < RI **************** @ verizon.net>写在
消息新闻：o5XTd.18050

"Richard Hollenbeck" <ri****************@verizon.net> wrote in message news:o5XTd.18050

这篇关于拼命寻求帮助过滤动态交叉表查询报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！