存取权中的枢纽分析表 [英] Pivot table in access

问题描述

我是新来的蜜蜂...
我有一张表格

HI I am a new bee to access...
HI I have a table as

它存储特定研究ID的医学类型ID

It store the Medical Type id for particular study id

查找医疗类型为

现在我还有另一个疾病查询表

Now I have another look up table for Disease as

现在，我希望数据透视表中的数据按研究ID和列分组为Medical_Type名称和相应的疾病名称，并带有Yes和No作为值 作为

Now I want the data in pivot for grouped by study id and column as Medical_Type names and corresponding disease name with Yes and No as there value as

我该如何实现...

谢谢

推荐答案

您可以

1.)从第一个表中左下两个表左联接(在视图构建器中，添加所有三个表，在链接列之间创建链接，然后双击创建的链接以选择定义人口的表)，

1.) left-join the two lower tables from the first one (in view builder, add all three tables, create a link between the linking columns and double-click the created link to select which table defines the population),

2.)创建一个交叉表

2.) create a crosstab

3.)将study_id设置为行

3.) set study_id as row

4.)将medical_type设置为列

4.) set medical_type as column

5.)代替y/n，您可以将"count(medical_type)"设置为值.

5.) instead of y/n you can set "count(medical_type)" as value.

如果坚持使用y/n，则可以使用交叉表作为输入来创建新视图并定义'iif(count> 0，"Y"，"N")'

If you insist on y/n, you can create a new view, using your crosstab as input and define 'iif(count>0,"Y","N")'

我希望这就是你想要的.

I hope this is what you wanted.

致谢

这篇关于存取权中的枢纽分析表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！