如何在Access中生成层次化的\级联查询\报告?

Let's say I have this data:

假设我有这个数据

 Name_Middle --- Name_First --- Name_Last --- User_Data --- Status
    Joe_2           Joe_1       Joe_3         Joe_data_1       OK
    Joe_2           Joe_1       Joe_3         Joe_data_2      !!!
    Joe_2           Joe_1       Joe_3         Joe_data_1       ОК
    Sam_2           Sam_1       Sam_3         Sam_data_1       ОК
    Sam_2           Sam_1       Sam_3         Sam_data_2      !!!
    Sam_2           Sam_1       Sam_3         Sam_data_3       ОК`

I need to display it in such format:

我需要以这种格式显示:

 Name_Middle --- Name_First --- Name_Last --- User_Data --- Data_Status
    Joe_2           Joe_1       Joe_3         Joe_data_1       OK
                                              Joe_data_2      !!!
                                              Joe_data_1       ОК
    Sam_2           Sam_1       Sam_3         Sam_data_1       ОК
                                              Sam_data_2      !!!
                                              Sam_data_3       ОК`

I could not figure out how to group data by multiple fileds in Access report without combining it in one field (in this case I would lose the ability to sort by first/last name, for example).

我不知道如何在访问报告中使用多个fileds来分组数据，而不将其合并到一个字段中(在本例中，我将失去以first/last名称排序的能力)。

And I don't like the report format, I want the data in pure datasheet view, so I could filter/sort it. Probably the Excel would be the better tool?

我不喜欢报告格式，我想要数据在纯数据表视图中，这样我就可以过滤/排序它。也许Excel是更好的工具?

I would appreciate any tips, thanks!

如果您有什么建议，我将不胜感激，谢谢!

1 个解决方案

#1

I haven't used reports in years but isn't this exactly what you're trying to do?

我已经很多年没有使用报告了，但这不是你想要做的吗?

You can group by more than one field in block format:

您可以以块格式对多个字段进行分组:

Report Design View

报告设计视图

---

More Information:

• Office.com : Create a grouped or summary report

  创建一个分组报告或摘要报告

• DataMagazine : Access: Grouped Report

  访问:分组报告

• TechRepublic : How to group an Access report on the fly

  TechRepublic:如何实时生成访问报告

• Quackit : How to Group a Report by Multiple Fields in Access 2016

  Quackit:如何在Access 2016中按多个字段分组报告