Write SQL query that will populate data from Access to Excelsheet using conditions

I have an Access table which has following fields:

ScanDate Number DataType
Type Number
Type1 Number
Type2 Number
BatchNo Number
Cases Number
Pages Number


Now I have a useform in Excel so that when the user selects the Date from the combobox then it should check for
total batch numbers (Count(BatchNo)), total cases (Sum(Cases)),Total Pages(Sum(Pages)) where ScanDate= Date from the combobox group by Queue Number. The Queue Number consist of Type+Type1+Type2.

Please see attached the Excelsheet where the data should be populated to.

Thanks for looking. Hope anyone can help me in this.

Hi Guys

Just can't figure out how to do Group By Queue Number. Because Queue Number is not the field. In actual Queue Number consisit of Type+Type1+Type2. These three are the fields in Access table.

Can't ring a bell how to do it.. Please help me in this.

Thanks