This is one I hacked together to test self-joins, creating one table to hold a variety of user defined fields with just one table, and changing the color of reports for the application module (i.e. Hr = Human Resources). We have tbl_Hr_Dept for departments in an organization. A department is a place where people can do some work.
By using self joins and a sort field, one can create an organizational report from the board on down to every department.
The tbl_Au_AppGrp allows for the client to define their own structures on top of my standard application. They are called groups and are hierarchical.
I cleaned up some sorting and grouping from the prior sample report in post #13
To see the "org report" run rpt_Hr_GrpDeptLu5.