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.