Number format

[COMPSCI610]

I am importing upc numbers from an AS400 file into an access database. My
problem is that when I run a query on the linked table, the numbers show up
in scientific notation. How can I get these numbers to show as a whole
number. Any comments would help.

 

[Ken Sheridan]

I am importing upc numbers from an AS400 file into an access database.  My
problem is that when I run a query on the linked table, the numbers show up
in scientific notation.  How can I get these numbers to show as a whole
number.  Any comments would help.

If you are viewing the query's results as a datasheet It may simply be
that the column width is too narrow to show the number in decimal
notation. If a number won't fit the column then Access displays it in
scientific notation. Try widening the column.

Ken Sheridan
Stafford, England

 

[John W. Vinson]

I am importing upc numbers from an AS400 file into an access database. My
problem is that when I run a query on the linked table, the numbers show up
in scientific notation. How can I get these numbers to show as a whole
number. Any comments would help.

Use a Text field for these UPC codes. They're not really numbers in the sense
that you'll ever do calculations with them; and if it's a ten-digit number
it's very likely to give an error since Long Integers are limited to no bigger
than 2147483647.

 

[John Spencer (MVP)]

Since you aren't going to be doing arithmetic with UPC numbers, try storing
the numbers in a text field if you can. Otherwise try widening the column
that is displaying the number.

How long are the UPC numbers and how large are they?

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Ron2006]

I don't know that much about UPC codes but if it Access thinks that it
is a number then you will NOT see any leading 0s.

Just one more reason to treat it as alphabetic.

Ron