Re;Looking Alternative to fldDateTime PrimaryKey

Ð

ÐÜË«

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top