CrossTab查询三个表

本文介绍了CrossTab查询三个表的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我正在尝试在交叉表查询中连接三个表。 Tbl-1字段 - 员工 Tbl-2字段 - 文档 Tbl-3字段 - 员工文档浏览 我正在尝试的是获取交叉表查询或Vb模块，该模块可以列出Tbl-1中的所有人员作为行标题和来自Tbl的所有文档-2作为列标题并放置是或否如果工作人员查看了Tbl-3中可用的文件 非常感谢有人可以帮助我 问候

解决方案

创建一个返回所有这些值的正常选择查询（Q）。 一旦完成，交叉表应该很容易基于（Q）创建

感谢您的回复。但我尝试过这种方法。交叉表仅返回具有Viewed的人员。但我的问题是我需要看到Tbl-1的所有工作人员，Tbl-2中的所有文件和价值字段，以显示工作人员查看和工作人员姓名不在Tbl-3中，但在Tbl-1中可用。 作为一个例子，如果员工Tbl中的员工总数为100，而Tbl-3只有90名员工详细信息，他们查看了我需要交叉排行源的文档，包含100名员工，列标题包含文档名称和值根据所查看的状态为是或否。被查看的字段是日期字段。 我可以生成交叉表，其中有90名员工在Tbl-3中可用，但是来自Tbl-1的其他10名员工没有显示。请帮忙。 再次感谢

创建选择查询，切换到piviot表视图，将字段拖放到正确的区域枢轴表。 V2003： office.microsoft/en-us/ac...001034580.aspx V2010： office.microsoft/en-us/ac...101901543.aspx

I am trying to connect three tables in a crosstab query. Tbl-1 Field - Staff Tbl-2 Field - Document Tbl-3 Fields - Staff Document Viewed What I am trying is to get a crosstab query or Vb module which can list all the staff from Tbl-1 as the row heading and all the Documents from Tbl-2 as the Column heading and put "Yes" or "No" if the staff viewed the document which is available in Tbl-3 Much appreciated if someone can help me Regards

解决方案

Create a normal select query (Q) that returns all of these values. Once that is done the cross-tab should be quite easy to create based on (Q)

Thank you for the response. But I have tried that approach. The crosstab returns only the staff with Viewed. But my issue is I need to see all the staff from Tbl-1, all the documents in Tbl-2 and the value field to show the staff viewed and the staff names not in the Tbl-3 but available in Tbl-1. As an example if total staff is 100 in Staff Tbl and Tbl-3 has only 90 staff details who viewed the document I need to crosstab Row source with 100 staff, column heading with the document names and the values as yes or no according to the status of viewed. The viewed field is a date field. I can generate the crosstab with 90 staff who are available in Tbl-3, but the other 10 staff from the Tbl-1 is not showing. Please help. Thank you once again

Create the select query, change to piviot table view, drag and drop the fields into the correct areas of the piviot table. V2003: office.microsoft/en-us/ac...001034580.aspx V2010: office.microsoft/en-us/ac...101901543.aspx