FieldSize in Number Fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?
 
What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?
Click to expand...

If the "number" is being used as an identifier rather than for
mathematical calculations, use a Text datatype rather than any sort of
Number. Long Integers are limited to up to two billion odd (2^31 - 1),
Doubles to 13 or 14 decimal places.


John W. Vinson[MVP]
 
What is the longest string of numbers that you can have in a Number Field.
I have an eBay database I have created and it was fine inputting the item #
into the field until the item #'s have reached 12 numbers long. Now, when i
put the data in it automatically changes it to be scientific mode even though
the field is set to be in general.
For example

original number = 320003721207

Access changes it to = 3.20003721207E+11

Can anyone help?
Click to expand...

Are you ever going to add Item# 320003721207 + Item# 320003721208 ?
Of course not.
Change the field datatype to Text and you won't have to worry about
the length of the field. Set the Field Size to 255.
 
John said:
If the "number" is being used as an identifier rather than for
mathematical calculations, use a Text datatype rather than any sort of
Number. Long Integers are limited to up to two billion odd (2^31 - 1),
Doubles to 13 or 14 decimal places.
Click to expand...

Note that a DECIMAL can accommodate up to 28 digits to the left of the
decimal point; in fact Access/Jet will natively consider such values to
be DECIMAL in nature e.g.

SELECT
1234567890123456789012345678
AS dec_value,
TYPENAME(dec_value) AS dec_type
FROM AnyTable;

and dec_type = 'Decimal'.

Go beyond the 28 digits and the number will be considered as FLOAT
(Double) and the numeric value will only show max 15 significant
figures.

But I agree this 'eBay number' is text rather than numeric.

Jamie.

--
 
Back
Top