报表中显示的信息太多，无法通过查询...第2部分 [英] Too much info showing in a report run off of a query...part 2
问题描述
我有一个运行查询的报告。该报告应该显示当前撤回的项目。每次物品被撤回时，我都会遇到一个问题，即使它已被退回。所以我把日期按最大值分组。如果该项目仅由一个人撤回，则解决了该问题。但是，如果超过历史记录的人超过该项目，则会显示该项目根据该人员ID提取的最后日期（最大值）。
我只需要它来显示当前的内容。我试图做到这一点，如果订单日期大于它不会显示的返回日期，但那不起作用，我去了所有crosseyed试图找出它。所以...帮助？！？！我现在正在使用Access for MS Office Professional 2003.
这是代码：
I have a report that runs off of a query. The report is supposed to show the items that are currently withdrawn. I had an issue with it showing every time an item had been withdrawn, even though it had been returned. So I grouped the date by max. This solves the issue if the item had only ever been withdrawn by one person. However if more than one person over ''history'' has removed the item it shows the last date (max) that the item was withdrawn under that persons ID.
I just need it to show what is current. I have tried to make it so that if the order date is greater than the return date it won''t show, but that didn''t work and I went all crosseyed trying to figure it out. So...help?!?! I''m now using Access for MS Office Professional 2003.
Here is the code:
推荐答案
我有一个运行查询的报告。该报告应该显示当前撤回的项目。每次物品被撤回时，我都会遇到一个问题，即使它已被退回。所以我把日期按最大值分组。如果该项目仅由一个人撤回，则解决了该问题。但是，如果超过历史记录的人超过该项目，则会显示该项目根据该人员ID提取的最后日期（最大值）。
我只需要它来显示当前的内容。我试图做到这一点，如果订单日期大于它不会显示的返回日期，但那不起作用，我去了所有crosseyed试图找出它。所以...帮助？！？！我现在正在使用Access for MS Office Professional 2003.
这是代码：
I have a report that runs off of a query. The report is supposed to show the items that are currently withdrawn. I had an issue with it showing every time an item had been withdrawn, even though it had been returned. So I grouped the date by max. This solves the issue if the item had only ever been withdrawn by one person. However if more than one person over ''history'' has removed the item it shows the last date (max) that the item was withdrawn under that persons ID.
I just need it to show what is current. I have tried to make it so that if the order date is greater than the return date it won''t show, but that didn''t work and I went all crosseyed trying to figure it out. So...help?!?! I''m now using Access for MS Office Professional 2003.
Here is the code:
Christina123，
我认为您最简单的解决方案是单独保留查询，并使用排序和分组工具在由员工进行分组之前，将设计者报告给Group By Serial＃和MaxOfOrderDate。
Christina123,
I think your easiest solution is to leave the query alone, and use the sorting and grouping tool in the report designer to Group By Serial # and MaxOfOrderDate before grouping by the employee.
我尝试了所有分组选项，按日期然后串行，按序列，然后按日期等....，但在每种情况下我都显示最后一次项目由每个员工取出。
I tried all of the grouping options, by date then serial, by serial then date etc...., but in each case I was shown the last time the item was taken out by each employee.
我尝试了所有分组选项，按日期，然后是序列，按序列，然后是日期等。 ......，但在每种情况下，我都会看到每个员工最后一次取出物品。
I tried all of the grouping options, by date then serial, by serial then date etc...., but in each case I was shown the last time the item was taken out by each employee.
现在我很困惑！您说当您按员工分组时，最大订单日期会为您提供每个员工最后一次取出该项目的时间。因此，在您的报告中，首先按序列＃进行分组，然后按MaxOrderDate进行分组，并取消员工的分组。这应该为每个序列号提供MaxOrderDate。
Now I am confused! You said that when you grouped by employee, the Max order date gave you the last time the item was taken out by each employee. So in your report, group and sort first by Serial# then by MaxOrderDate and eliminate the grouping by employee. That should give you the MaxOrderDate for each serial #.
这篇关于报表中显示的信息太多，无法通过查询...第2部分的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
