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?
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?