I have to make updates to a critical production Voters table called tblCamp_ct. I'm looking for another set of eyes on this before I execute it. It should be really simply but I have to be sure.

The requirements are:

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


1) "Anyone who voted R in 2010 is an R regardless of if they voted D in 2008 or 2006"


which means

UPDATE tblCamp_ct SET Party = 'R' WHERE Voted2010 = 'R'   -- Don't worry about 2006 or 2008

2) "Anyone who voted R in 2008 is an R unless they voted D in both 2010 and 2006"


which means,

UPDATE tblCamp_ct SET Party = 'R' WHERE Voted20008 = 'R' AND (Voted2010 != 'D' AND Voted2006 != 'D' )

3) "Anyone who voted R in 2006 is an R unless they voted D in either 2008 or 2010"


which means,

UPDATE tblCamp_ct SET Party = 'R' WHERE Voted20006 = 'R' AND (Voted2008 != 'D' AND Voted2010 != 'D' )

Sound about right?