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