Extract data from Access table into excelsheet

[aman1234]

Hi guys

I want to extarct data from Access table and store that in the excelsheet as attached. I have designed userforms in excel which store data in Access table. Now I want to generate a report that will find the total number of documents before 8:00,08:30,09:00 etc.... for the date range selected. The following code doesn't work as required and it requires some changes:

Please Login or Register  to view this content.

I hope anyone can change the code accordingly.

Thanks