I have linked to an odbc datasource which is a table in an oracle database. In oracle the field would display a whole number such as 410000000000020000000. In oracle it's defined as number and 21. When I view the table in access the numbers appear like this, 5.161210817784058105E+18. How can I get the number to display correctly as a whole number.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access Link Incorrectly Interprets field as decimal/scientific
- Thread starter episudics
- Start date
Similar threads
- Locked
- Question