convert "yes" to '2' then add all fields
From: PaulFort (PaulFort_at_discussions.microsoft.com)
Date: 10/25/04
- Next message: John S. Ford, MD: "Re: Strange behavior moving from Access 97 to Access 2000"
- Previous message: CrazyHorse: "FindFirst not populating text box with results"
- Next in thread: Douglas J. Steele: "Re: convert "yes" to '2' then add all fields"
- Reply: Douglas J. Steele: "Re: convert "yes" to '2' then add all fields"
- Messages sorted by: [ date ] [ thread ]
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
- Next message: John S. Ford, MD: "Re: Strange behavior moving from Access 97 to Access 2000"
- Previous message: CrazyHorse: "FindFirst not populating text box with results"
- Next in thread: Douglas J. Steele: "Re: convert "yes" to '2' then add all fields"
- Reply: Douglas J. Steele: "Re: convert "yes" to '2' then add all fields"
- Messages sorted by: [ date ] [ thread ]