Q:

How do I make hierarchical\cascading query\report in 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). 
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?
I would appreciate any tips, thanks!

A:

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
Quackit : How to Group a Report by Multiple Fields in Access 2016

