Decimal places in linked SQL table

P

Pierre Letourneau

I have an SQL table that has a data filed that has 20 decimal places. When I
link this table to access I can only see the rounded version of the number.
How can I get access to display all decimal places?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Issue with Data Types when linking to SQL Server 2
Using project as a resource tracker 0
ODBC link converting Decimal to Long Int 1
Converting decimal degrees to degrees, minutes & seconds 2
exporting as text cutting off significant digits 2
link table from txt file 0

Top