Linked Table Layout

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

Guest

I have a table that comes our SQL Database. I'm taking a look at the order number field in SQL and it displays as 200200000000 while in access it displays as 2.0020000E+11 in tables. Why is this and how can I correct it.
 
You can store this number as a *whole* number of type "bigint" (64-bit) in
SQL database but Access/VBA don't have the equivalent whole-number data-type
(in Access, Long is only 32-bit data-type which is too small to store your
number) and therefore Access treat the number as Double.

Sorry, I don't know the solution if you want to treat the number as a
*whole* number.

--
HTH
Van T. Dinh
MVP (Access)



George Schneider said:
I have a table that comes our SQL Database. I'm taking a look at the
Click to expand...
order number field in SQL and it displays as 200200000000 while in access
it displays as 2.0020000E+11 in tables. Why is this and how can I correct
it.
 
Back
Top