[AccessD] Number vs text data type

Brock, Christian T, HRC-Alexandria Christian.Brock at hoffman.army.mil
Thu Oct 16 08:32:53 CDT 2003


A date is a number.  It is the count of years, etc from a given start point.

Christian Brock

-----Original Message-----
From: Henry Simpson [mailto:hsimpson88 at hotmail.com] 
Sent: Wednesday, 15 October 2003 21:56
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] Number vs text data type


<SNIPPED>
Also, things like spaces, parentheses and hyphens can be used in formatting
a numeric 
value.  Why do you suppose Microsoft and other software vendors store dates 
as numeric values?  Speed, efficiency and format flexibility.

Hen




More information about the AccessD mailing list