I have a voter database that contains the information for 25,000 registered voters. What I'm trying to do is track the number of times each person has voted over an 11 year period. I have the polling results for each of the 11 years. All the fields are consistent from year to year. The primary key is the voter  ”Identification Number”. What I am trying to do is generate a report that lists the Voter ID, First and Last Name, their Home Address and a column for each of the 11 years. I want to be able to determine the voting patterns of the individual voters. I need to determine if they have voted in local, state or national elections and also to have a “Total” column as well. The data for each year has a column labeled “Voted”, and if they voted it will have a 1 in it.  Now I have been able to do grouping and sorting to get some of my results but not able to pinpoint the type of elections they participated in.
This database has a table for each one of the 11 years
Any help in this endeavor would truly be appreciated. Thanks in advance.
Bob Lilly