After many hours of cleanup on the database I am helping with, I have discovered that there is a very large annual report that needs to be compiled each year. As you can see in the attached example, Sample.accdb there are MANY lookup fields for this table. In the actual database, there are separate tables for the values in each of these lookup fields. The annual report only counts events that occurred during the current calendar year:
Number of wins/losses/mixed reviews at level #1, level #2, level #3 (each win/loss/mixed counted separately)
Number of cases settled at level #1
Number of hearings held
Total of all settlements/awards
And so much more.....
How would I accomplish this? The database continues to grow, (approx 600 cases at this time) as some cases can take years to work through the process. They may lose at Level#1 in 2017, but win Level#2 in 2018. If I add a date/time column ahead of each of these fields, that makes the database clumsy to use and increases the number of queries that must be designed to compile the annual report.
My friend that I am helping would like for all this to happen with the click of a button and send the report to excel. However, since I am not a programmer, I don't know if this can even be done, and I am just about ready to punt. Any ideas or advice would be greatly appreciated!