On Mon, 4 May 2009 08:53:47 -0400, "David" wrote:
>> Not sure if this is relevant to the very peculiar issue that you
>> describe!
>
>The SQL query isn't but the paragraph after is. Put in query for a
>complete
>read.
>
>Since Access uses a double to hold a date, that precision can go out to
>milliseconds. Access only displays dates to the second. Read some
>conflicting articles though that Access 97 (which I'm using) also only
>stores to second --- but I don't buy it .
>
>My guess is that each time I pass in [pDateEnd] and subsequently use this
>value in Seek, that the double is slightly different because of the
>milliseconds. Hence two records which display the same but are actually
>different.
>
>However, In trying compare both records with the same date in Access
>(debug.Print from VB5), it shows as the same datetime.
>
>Any idea how you can display milliseconds?
I'm not sure that this is the problem, but you could try using CDbl() to
convert the date time to a double, and multiply by 86400 to convert days
(date/time) to seconds.
FAQ
Search
Profile
Private Messages
Log in
