I have two tables - [Employees] and [Types](eg Medical, Super etc); a query one to many - with some employees having more different types than others.
I am trying to output a report with [Employee Name] as a heading, then a subheading ie Medical with [Type] eg showing medical details and then if there are more details for that Employee, another subheading like Super with [Type] showing super details.
Any help would be appreciated.