I currently have a database with all of our company's inventory listed in it. I am needing to create a report that summarizes all of a department's inventory. I would then like to export this report to different Excel workbooks saved as the department name so it can be emailed to the department head.
I'm stumped on how to begin this... Will I need to begin with a query or do it all in VBA with a loop procedure checking for a change in department ? I consider myself fluent on the Excel side of VBA but I'm hoping to do this all in Access with programming. I'm also hoping I can get some help on beginning the VBA code in Access since it's a little different than Excel.
This is kind of the format I would like to use where the data enclosed in brackets are fields in my database:
For each department, write a report in this format (naming the workbook with the department name):
Header: <Department Name>'s Inventory - Bold/Large Font
<Department Head Name> - Medium Font
Column Names - Bold/Underlined/Color Shaded
All Inventory listed in tabular format - Plain text
As you can see, it's a fairly simple style. I will probably dress up the report by programming the font/shading changes.