Kaup, Chester
Chester_Kaup at kindermorgan.com
Tue Aug 16 16:23:58 CDT 2005
Below is a piece of code. DaysInMonth is a function. When the code runs and hits the line myds1.Fields(2) = Nz(myds4.Fields(8)) the function runs. I don't see anything that is calling it. Your thoughts appreciated. Do Until myds4.EOF DaysinMonth = DaysInMonth2(myds3.Fields(1)) If Day(myds3.Fields(1)) < DaysinMonth And RecordCounter = 1 Then StartCounter = Day(myds3.Fields(1)) ProdDate = myds3.Fields(1) Else StartCounter = 1 ProdDate = myds4.Fields(1) End If For I = StartCounter To DaysinMonth myds1.AddNew myds1.Fields(0) = ProdDate myds1.Fields(1) = myds4.Fields(0) myds1.Fields(2) = Nz(myds4.Fields(8)) myds1.Update ProdDate = ProdDate + 1 Next I RecordCounter = RecordCounter + 1 myds4.MoveNext Loop Chester Kaup Engineering Technician Kinder Morgan CO2 Company, LLP Office (432) 688-3797 FAX (432) 688-3799 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced.