[AccessD] Data Types and Number of Characters

Fri Apr 9 11:18:40 CDT 2004

Liz,

Thanks for the information.  Just had a new hard drive put in and the LAN
admin seems to have not put everything back on my pc, like help files...
Cannot wait to find out what other little surprise await.

                      "Liz Doering"                                                                                                            
                      <liz at symphonyinfo.com>           To:       "'Access Developers discussion and problem solving'"                          
                      Sent by:                          <accessd at databaseadvisors.com>                                                         
                      accessd-bounces at databasea        cc:                                                                                     
                      dvisors.com                      Subject:  RE: [AccessD] Data Types and Number of Characters                             

                      04/08/2004 12:18 PM                                                                                                      
                      Please respond to "Access                                                                                                
                      Developers discussion and                                                                                                
                      problem solving"                                                                                                         

Jeffrey,

This is from Access 97 help:

Byte         Stores numbers from 0 to 255 (no fractions).
 1 byte
Integer            Stores numbers from -32,768 to 32,767 (no fractions).
       2 bytes
Long Integer             (Default) Stores numbers from -2,147,483,648 to
2,147,483,647 (no fractions).        4 bytes
Single             Stores numbers from -3.402823E38 to -1.401298E-45 for
negative
values and from 1.401298E-45 to 3.402823E38 for positive values.         4
bytes
Double             Stores numbers from -1.79769313486231E308 to
-4.94065645841247E-324
for negative values and from 1.79769313486231E308 to 4.94065645841247E-324
for positive values.           8 bytes

Hope this helps,

Liz Doering
Symphony Information Services
liz at symphonyinfo.com
www.symphonyinfo.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
jeffrey.demulling at usbank.com
Sent: Thursday, April 08, 2004 11:48 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Data Types and Number of Characters

Starting to become a rough day and need some help here as.

Given the various data types in access what is the maximum number of
characters for each one.  I am not asking about the storage size, but the
actual characters displayed.

I think an example would help:

An Integer has a storage size of 2 bytes but the number of characters
maximum that will be displayed is 6.

The other data types I am wondering about are:

Long
Single
Double
Currency
Decimal

Hopefully this make sense.  Thanks for any help in advance.

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

--
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com