When I link to a SQL Server 2000 table from Access (97 or 2000), a column that is defined in SQL Server as decimal, 4 digits to right of decimal point, shows as a currency column in the Access link and is rounded to 2 decimal places. These happen to be currency columns as far as the real data, but the problem is that the display in Access is rounding to 2 decminal places unless you do some formatting. It should display all 4 decimal places when I open the table. How can I fix this problem?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access link to SQL table for 4 digit decimal shows 2 digits
- Thread starter BSman
- Start date
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
