convert "yes" to '2' then add all fields

From: PaulFort (PaulFort_at_discussions.microsoft.com)
Date: 10/25/04


Date: Mon, 25 Oct 2004 11:34:39 -0700

Hi All,
This should be simple....
To make my question clear, I put a demo table here:
http://tallahasseech.org/accessquestion.htm

- I want to assign the number '2' to each yes and assign '1' to a "no"

- I want to then add up all the numbers in the fields for each record (person)

> So the answers for my demo would be:
tom = 7 (2+2+2+1)
tim = 6 (1+2+2+1)
james = 0

How do I do this.
I appreciate the help.
Paul