I have a table called tblRDH2005. It has 1 field for region and then 41 fields used for a questionaire. The 41 fields are L1...L41 and their options can be only 1,2,3,4,5 (each number representing a severity from strongly disagree to strongly agree with 3 being neutral).
What I would like to do is run some looping and addition. Say loop through all fields L1 thru L41 where region is like Washington and severity = "5", each instance of "5" I would like to add "1" for a running count to a field called Washington5. I would need to do this for (4)(3)(2)(1) also for Washington. And the same for Oregon and Idaho. I don't know if I would need to use a temporary variable instead of an actual field. And I am not sure how to initially open and update a recordset in VBA.
Any help would be appreciated.
What I would like to do is run some looping and addition. Say loop through all fields L1 thru L41 where region is like Washington and severity = "5", each instance of "5" I would like to add "1" for a running count to a field called Washington5. I would need to do this for (4)(3)(2)(1) also for Washington. And the same for Oregon and Idaho. I don't know if I would need to use a temporary variable instead of an actual field. And I am not sure how to initially open and update a recordset in VBA.
Any help would be appreciated.