Issue with Data Types when linking to SQL Server

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
 
R

Robin9876

I should have mentioned preferably without using a data conversion
functions with Access.
 
K

Klatuu

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

React JS Outlook Add-in - VS Code + WebPack - Unable to call external Web Service - CORS Issue 0
Excel does not accept text format! 0
Outlook Add-in - Javascript based using React JS - VS Code + WebPack - Unable to call external Web Service 0
SQL Custom Data Types Not Visible In Access Linked Tables 1
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
#DELETE in all fields after linking to SQL Server table 1
Move Chart with Text 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0

Top