[AccessD] Value Truncated in Access Link to SQL Server Table

Paul Hartland paul.hartland at googlemail.com
Mon Jul 1 08:24:17 CDT 2013


In the past I have also used the decimal field type so you should be able
to have decimal(18, 6) as well as a float type


On 1 July 2013 14:08, Dan Waters <df.waters at comcast.net> wrote:

> What I needed to do was to use the Float data type in SQL Server.  Then the
> ODBC table link in Access would see the entire value.
>
> Dan
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Saturday, June 29, 2013 12:24 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Value Truncated in Access Link to SQL Server Table
>
> Hello!
>
>
>
> I have a table in SQL Server which has a field named SalesTaxRate.  This
> field has a type of Numeric(18,6).  The value I entered is 0.07125, and it
> displays in SQL Server as 0.071250 which is correct.
>
>
>
> But when I open the ODBC link to this table in Access, the value shows as
> .07.
>
>
>
> I've tried using a Decimal field, changing the precision and scale values,
> and re-creating the table link.  All to no avail.
>
>
>
> Anyone know how to fix this?
>
>
>
> Thanks!
>
> Dan
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
Paul Hartland
paul.hartland at googlemail.com


More information about the AccessD mailing list