Fetch weekly data from Access database

Hi guys

I have built an application in Excel as a frontend and Access as a backend. The Access database stores all the data which is present in sheet1 of the attached workbook. I want to generate a weekly report as shown in sheet2 of the attached workbook. When the user selects the "week ending date" from the 3 dropdown boxes(dd,mm,yyyy") then the whole week data should be pulled from the Access database and should be printed off as shown in sheet2 in the attached workbook. The sheet1 is just an example how the Access database stores the data but in actual I am not storing any data in excel spreadsheet as everything gets stores in Access database.

Thanks a lot for any help in advance!!!!

Hi snb

Thank you so much for your reply.My old thread "Generate weekly report" was related to the application developed all in excel and then I changed the backing database to Access . Now in this thread I want to pull infromation from Access database and print out a report. Could you please guide me how to do this.

Thanks