Integer maximum value

[Alan T]

I have define a field type as integer.
I tried to put a value 120,000 but it seems exceeds the value.

 

[Rob Parker]

Hi Alan,

An integer field stores numbers from -32,768 to 32,767. A long integer
field stores numbers from -2,147,483,648 to 2,147,483,647. So, just change
the field size from integer to long integer, and you should be OK.

Help on Field Size gives the specifications for all the data types
available.

HTH,

Rob

 

[Larry Linson]

I have define a field type as integer.
I tried to put a value 120,000 but it
seems exceeds the value.

Did you check Help on Fields and Variables? An integer in Access can range
from -32768 to +32767. You'll need to define a Long Integer to hold a
number as big as 120,000 -- how about you take as a homework assignment
checking Access Help and elsewhere and posting back here the value range for
a Long Integer?

Larry Linson
Microsoft Access MVP