Here is information on how Access stores dates
http://support.microsoft.com/kb/210276
Access stores dates the same way Excel does.
Bob Peterson
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Jerry Mathers
Sent: Thursday, April 11, 2013 2:03 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Converting time to a number
I have a field that is a date datatype (short time). Lots of data have (has?) already been entered. It was a mistake to use a date datatype so is there a reasonably easy way to convert all of the times to numbers. I know that Access stores dates and times in an unusual way and everything I've tired so far gets me "interesting" results.
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Tidak ada komentar:
Posting Komentar