Re: distinct and yet duplicates

Tech-Archive recommends: Fix windows errors by optimizing your registry

patti wrote:
The field in the table is formatted for short date. How is access
really storing it?


No, the "data*** that is used to view the table" is formatted to display
the date as "short date". Formatting never makes any difference to how data
is stored (regardless of the data type). What is unique about DateTimes is
that they are always using a format of some kind because the raw data that
is stored in not meaningful to the user.

Access DateTimes are stored under the covers as a Double numeric type where
the integer portion of the number is the count of days since December 30,
1899 and the fractional portion of the number is a percentage of the 24 hour
clock for that date. Right now as I type the current DateTime is...

4/1/2008 2:43:26 PM

This would be stored as the number...

39539.6134953704

So you might have lots of DateTime values which appear identical when shown
in short date format, but where the underlying numbers are quite different.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


.

Quantcast