Number Longer than Long Interger

  • Thread starter Thread starter Guest
  • Start date Start date
Can I make a number longer than Long Integer in Access? If so, How? Thanks.

A Currency datatype will provide values into the trillions; a Double
Float will allow up to 14 decimal places of accuracy.

If you're using this value for an identifier - a part number, an
accont number, or the like - and will not be doing calculations with
it, use a Text datatype instead. This allows up to 255 digits <g>.

John W. Vinson[MVP]
 
I never thought about the text data type, but you are right. The field I
need will be all numerical data, but I do not need to perform calculations
with it. I will make it text, and limit the characters to numerical ones.
Thank You.
 
Back
Top