I asked both the same questions you guys did to the client last night.

We updated all Party values to NULL before running them. I also got more clarification from the client on when a person is an R vs a D.

Thanks guys

>>>1) Anyone who voted R in 2010 is an R regardless of if they voted D in 2008 or 2006
>2) Anyone who voted R in 2008 is an R unless they voted D in both 2010 and 2006
>3) Anyone who voted R in 2006 is an R unless they voted D in either 2008 or 2010
>My queries then should be
>
>Is a person either R or D or is a person R or not R?
>
>I'm bleary-eyed but it seems that if someone voted R in 2010, R in 2006 and D in 2008, that person would be an R under rule 1 but not under rule 3.
>
>Am i correct?
>If so which one would take precedence?