Hey there,

Everytime equation comes to zero my program runs into an infinate loop.. Anyone knows why... i'm actually subtracting one date from the other using date diff....

my codes are as such

VB Code:
  1. DateHold = Rs.Fields("TimeStamp")
  2.  
  3. Rs.MoveNext
  4.  
  5. Do While Not Rs.EOF
  6.  
  7.     DateCompare = Rs.Fields("TimeStamp")
  8.     Debug.Print DateCompare
  9.     Debug.Print DateHold
  10.     Subtract = DateDiff("s", DateHold, DateCompare)
  11.     Debug.Print Subtract
  12.     Rs!AmountTime = Subtract
  13.     DateHold = DateCompare
  14.     DateValidate = Rs.Fields("AmountTime")
  15.    
  16.     For i = 1 To 2000
  17.     DoEvents
  18.     Next i
  19.    
  20.     Debug.Print DateValidate
  21.    
  22.         If (DateValidate <= -1) Then
  23.                  
  24.             DeleteDateValidate (DateValidate)
  25.                  
  26.         End If
  27.        
  28.    Rs.MoveNext
  29.  
  30. Loop
  31.  
  32. Rs.Close
  33.  
  34.  
  35. Thanks!