I was looking to solve the same question and found the solution for it. At least on Access 365 there is a solution. In the Query design window instead of "Group by" select "Expression" in the dropdown for the new calculated field based on other calculated fields.