dw85745,

Code looks clean. One thing you don't do is to set you recordset to equal nothing when you are done. This is VB6 code correct?

When Access gets to the February 1937 daily record it resets the pointer back to the first Daily record.
Feb 1937 Daily record? I don't see any year calculations in the sub. How do you know not to roll-over?