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.