Dan Waters
df.waters at comcast.net
Mon Jul 1 08:08:02 CDT 2013
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