Jim Lawrence
accessd at shaw.ca
Mon Jul 1 11:08:47 CDT 2013
Hi Dan: When working for a client many years ago, their database could not handle numbers with say twenty decimal places so we made a system that converted a number to an integer, save the mantissa (number of values below the decimal point) and stored the values in two fields. For presentation the process was reversed. All of this was done via a simple function. Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Monday, July 01, 2013 6:47 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Value Truncated in Access Link to SQL Server Table The problem was that I only got 2 decimal places instead of the 5 I needed. I was pretty surprised that a Decimal type in SQL Server couldn't be completely understood in an Access table link. I'm going to guess that there is something in the ODBC link which is insufficient for a SQL Server decimal type. Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Paul Hartland Sent: Monday, July 01, 2013 8:24 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Value Truncated in Access Link to SQL Server Table 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 -- 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