Decimal places not truncated in Access 2002

D

Dan

I've encountered a problem with reports not displaying
numeric data correctly with an Access 2002 ADP client
against a SQL Server database.

For example, with a numeric format and two decimal places
specified where I would expect to see 5.25 hours or
$125.25, the report may display 5.250000 or 125.25004932.

When I run Access 2000 against the same ADP file, the
report displays correctly. I've also tried converting
the ADP file to Access 2002 format, but the report still
seems to ignore the decimal places and format properties.

Has anyone else encountered this problem or found a work
around to correct it?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access stripping decimal places in query 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Decimal places doesn't seem to work 7
Conditional Decimal Places 7
How do I truncate decimal places on a merged field? 1
Access 2000 ADP and SQL Server 2005 2
Formatting decimal places 8
Decimal places in a calculated Text Box 9

Top