关系&报告 [英] Relationships & Reports

问题描述

大家好。我决定发帖，因为我是一个Access新手，并且不知道如何正确地将我的问题用作搜索词。


我有一个有两个表的数据库。一个包含设施列表，另一个包含工作订单列表，日期，小时，活动以及下拉选择设施。还有一个表单允许用户输入有关工作单的所有数据，并在该表单中下拉列表正确显示整个建筑物列表。


我需要一份报告，用户可以运行将显示以下内容：工作单，工厂，B / U，日期，活动和小时，B / U，工作单和工具是三个分组级别。


我使用向导做了一个报告，它返回了我需要的结果......除了它使用建筑表中的唯一ID而不是建筑物名称。我改变了关系，但那并没有解决它。我尝试更改控制源并返回#Error为了我的麻烦。附件是两个屏幕截图：第一个表格，表格和报告，第二个关系布局。


数据库的副本，少了一些半数据如果需要，可以提供专有数据。


表格，表格和报告：

Hello everyone. I decided to post because I''m an Access newbie and didn''t know how to properly phrase my problem as search terms.

I have a database that has two tables. One contains a list of facilities, the other a list of work orders, date, hours, activity, and a drop down to choose the facility. There is also a form that lets the user enter all the data about the work order, and in that form the drop down correctly shows the entire building list.

I need a report that the user can run that will show the following: the work order, facility, B/U, date, activity, and hours, with B/U, work order, and facility being the three grouping levels.

I made a report, using the wizard, and it returns the results I need...except that it''s using the unique ID from the building table instead of the building name. I changed the relationship, but that didn''t fix it. I tried changing the control source and got back "#Error" for my trouble. Attached are two screen shots: the first of the tables, the form, and the report, the second of the relationship layout.

A copy of the database, less a few tidbits of semi-proprietary data can be made available if need be.

Tables, Form, and Report:

推荐答案

您好奥斯汀，

听起来您在报告向导中输入了错误的信息。将查询与报表上所需的字段一起放置，并使用向导根据查询重新创建报表。忘了其他一切。

Hi Austin,
Sounds like you entered incorrect info into the report wizard. Put a query together with the fields that you want on the report and recreate the report using the wizard basing the report on your query. Forget about everything else.

willakawill，谢谢你的回复。


好​​的，我创建了一个查询，然后根据它创建了一个新的报告查询：

willakawill, thanks for the reply.

OK, I created a query and then created a new report based on that query:

如果查询正在运行报告没有反映报告返回的新值，您可能会遇到两个问题之一。

1.在运行报告之前，您还没有保存查询。

2.报告的过滤或排序集与本机查询的工作方式不同。

主要是我们正在盲目工作，因为图片中显示的报告似乎显示您查询中不存在的字段...

If the query is working but the report isn''t reflecting the new values returned by the report you could have one of two problems.
1. You haven''t saved the query before running the report.
2. The report has filtering or sorting set which works differently from the native query.
Mainly we''re working blind though, as the report as shown in the picture seems to be showing fields which aren''t there in your query...

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