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

Problem with numbers not formatting correctly 1
Limit decimal places without format statement 5
Data Analysis-Truncating Hours to display Zero decimal places 3
How do I truncate decimal places on a merged field? 1
SQL server link Access converting decimal to long integer 8
form-based parameters in a query (access 2003 - ADP) 8
Decimal places in report 2
Decimal places in a calculated Text Box 9

Top