Issue with Data Types when linking to SQL Server

  • Thread starter Thread starter Robin9876
  • Start date Start date
R

Robin9876

When linking from Access to a SQL Server table that has float fields,
is it possible that Access can return all numbers with a decimal? E.g.
123 would return 123.0000000000
 
I should have mentioned preferably without using a data conversion
functions with Access.
 
Access field values that have no numbers following the decimal are shown the
exact same way. If you want to show decimals, use the Format function.
 

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

Access stripping decimal places in query 1
SQL Custom Data Types Not Visible In Access Linked Tables 1
Cannot link to SQL server 17
Append data to linked SQL Server 2008 table 0
SQL Server 6
Sql Server linked table and NULL bit fields 2
Linked tables to SQL 1
Conneting to SQL server, Need advice 3

Back
Top