For some reason my integer, i, is not incrementing by 0.5. I have it defined as an integer. Any ideas? Thanks in advance.
Code:rs.FindFirst "[EmplID] = " & fldID i = -1 For Each fld In rs.Fields i = i + 0.5 If i > 0 Then If i = Int(i) Then vWeekVal = rs("Week" & i) If DatePart("ww", vWeekVal) = DatePart("ww", emplDate) Then If DatePart("yyyy", vWeekVal) = DatePart("yyyy", emplDate) Then rs.Edit rs("Exempt" & i).Value = -1 rs.Update End If End If End If End If Next fld