Jay,
>
>Almost quantum %) It's funny that you get a difference in display of the initial value and then storage/retrieval. I wonder if a DTOC() would help?
>
I'm betting it would. But I don't think I'm going to bother checking. BTW, the next group of duplicates is also a bundle of 24. It doesn't happen until record 276,514 (approx. 92,000 * 3). I'm convinced this isolated to incrementing datetimes...so this problem not is really relevant :)
>>I hope this is only a rounding issue, because I don't see any real situation where I would be incrementing time values in this manner.
>
>I agree. Now, if we had the same problem with integer values, I'D BE CONCERNED!
>
That's the truth!
take care,
Steve Gibson