I am fairly new to the reports side of access. I hope I can explain my issue clearly. So what I am trying to do is group information into 3 separate groups as follows:
----------------------------------------------------------------------------------------------------------------
Grouping 1:
Grouped by a specific field in my table named "LOAD-OUT", then by field AREA, and then by DISCIPLINE
Grouping 2:
When the 1st group has completed I want to start a 2nd grouping as follows:
Grouped by a specific field in my table named "TRANSPORT", then by field AREA, and then by DISCIPLINE
Grouping 3:
When the 2nd group has completed I want to start a 2nd grouping as follows:
Grouped by a specific field in my table named "LIFT", then by field AREA, and then by DISCIPLINE
----------------------------------------------------------------------------------------------------------------
I am have successfully, for the most part, gotten the 1st Group to work but then I need to repeat the process for the 2nd and 3rd grouping. I have provided an attachment to help show what I'm after.Report.pdf