Yes, we are dumping a rolling 12 month period. Looking back on our raw data dump, we actually have dates attached to each Occur (I had renamed the column in my table to take off the date in my first attempt to create our desired report).
What is your table name?
As it is today, how many fields do you have in the table?
What are the field names?

With the table structure you posted in post #1, do you add a field to the table each month?