Run query monthly

[Mike Hughes]

I would like to write a query which I could run each month to find out the number of times during that month and employer name is added to a table by the source.
Example:
During April
34 new employers were added to the table with a source of NHO
55 with a source of NHT
123 with a source of EMP
I'm only dealing with one table, EMP HISTORY. I can write the query and get the results that I want.
The question is how can I save the results to a table/spreadsheet where I can keep adding new information each month? Will I need to cut and paste to Excel each month or is there someway to store the new information with the information received from previous months. What I would like to do also is to create a chart showing the changes is source counts from month to month. Can anyone help?

 

[KKilfoil]

.

The question is how can I save the results to a table/spreadsheet where I can keep adding new information each month? Will I need to cut and paste to Excel each month or is there someway to store the new information with the information received from previous months. What I would like to do also is to create a chart showing the changes is source counts from month to month. Can anyone help?

If you create a summary query, you can use "group by" for your date field and count/sum of the source to show the statistical data for all months, and use a filter if you only want to see the current month. Then you need not store any data.