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.
 
Top