which data type?

  • Thread starter Thread starter placek
  • Start date Start date
P

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.
 
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
 
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
 
Back
Top