which data type?

[placek]

Hello

Long data types hold integers up to 10 digits. Which data
type do you use for integers of 11 digits or more?

Thanks, Martin.

 

[Alex Dybenko]

VBA/Jet do not support such types, but you can make your own and use
existing data types to store.
there are several solutions, search for "very long integer" in google

 

[Allen Browne]

The Double should give you about 15 digits of precision.

If you are utterly desperate, and using Access 2000 or later, you can use
the Decimal type for up to 28 digits. However, Access does not know how to
handle these numbers correctly. Example:
http://allenbrowne.com/bug-08.html