[AccessD] Data Types and Number of Characters

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