Exporting to Excel worksheet based on dates
The attached DB is being designed for use in grocery store produce departments. Users input data related to what is being thrown away, and it produces a report that rolls up that information.
I was working on a way to export the data so that it could be sent digitally to managers at higher headquarters, but they specifically want it in Excel.
Yes. Excel. Barbarians and Heathens all!
With that in mind, I am trying to create a widget within this DB that allows the user to export the data from Access to Excel, and the data would auto-populate worksheets within a workbook based on the date from the data.
How would this be possible? I've already created a query (Export) that gathers the necessary information, and I can export this in Excel format then cut &past into the Excel Workbook--I am just trying to cut out the middle man and get Access to do it on its own.