Do you have a table that is storing months this way?
Code:
HouseHoldID Jan Feb Mar Apr ....
1 Yes No Yes No
2 No No No Yes
Why wouldn't your attendance table be set up with the
Code:
HouseholdID AttendanceDate
1 1/1/2011
1 3/1/2011
2 4/1/2011
This would accomplish 2 things
1. You could update this table forever without having to reuse any fields (when the new year rolls over)
2. You could use the datepart("m",attendancedate) and datepart("yyyy", attendancedate) to see if a person had attended their monthly meeting for the current month or not