In Access, I have a table Called Data1 with around 120,000 records and eight columns as per the attached. I’m looking to produce a query that will Group the data by:
Company – Company appears grouped
Category - Subgrouped with Category
Shift – Subgrouped by Shift.
HR_Extras and HR_Totals should be totaled as per the below.
Structure should appear along the lines of
Have attached an access 2007 DB with the data as listed included and a word file displaying the requested format of the report.