I've created a database containing workload statistic data in a table called [sets]. I populate this table each month from an external source. Each month I run a few queries on the table to output the previous month workload data - example output shown below:
Data for month: Feb
Set name
I then copy & paste this into a pre-existing excel file for that particular month - example of excel sheet layout below:
Set name
This process is somewhat time consuming & kind of a manual process in excel. I would like to automate this whole process possibly making use of the report module in ms access. Can I replace what I currently do in excel with something produced in a report? If so, how? Bearing in mind there are times when a set can exist in the current month which has never been in use in any previous months .ie. appears for the first time. Also, there are instances where sets existing in previous months may not have work performed in the current month - hope this makes sense.
Data for month: Feb
Set name
Number of sets
set A10
set B20
set D40
I then copy & paste this into a pre-existing excel file for that particular month - example of excel sheet layout below:
Set name
Jan
Feb
set A
10
set B15
20
set C2
set D35
40
This process is somewhat time consuming & kind of a manual process in excel. I would like to automate this whole process possibly making use of the report module in ms access. Can I replace what I currently do in excel with something produced in a report? If so, how? Bearing in mind there are times when a set can exist in the current month which has never been in use in any previous months .ie. appears for the first time. Also, there are instances where sets existing in previous months may not have work performed in the current month - hope this makes sense.
