I want to count the number of records processed in each team when the user selects the specific day,month and year from the comboboxes(day,month,year) 

strsql = "Select Team,count(*) from tblmaster group by Team having Date1 = # " & Format(DateSerial(ComboBox3, ComboBox2, ComboBox1), "dd/mm/yyyy") & " #"
   rs.Open strsql, cn
Can anyone please make the corrections in this?

Thanks
Aman