decimal problems in reports


R

rong

I've got a report that multiplies items*price. I need the price carried
out to about 6 decimals.
Something like 6*$4.00643. No matter where I set the decimals
when I format either the price table or the control or both Access
wants to round to about 4 decimals. I've checked my queries, tables,
etc. and have the decimal to at least 8 places but I can't get it to
work.
Do I need to change the price from currency to a regular number?
Thanks,
rong
 
Ad

Advertisements

S

Steve Schapel

Rong,

Fields with a Currency data type are accurate to 4 decimal places.
Looks like you will need to use a Number data type, with Field Size set
to Single.
 
R

rong

Thank your Steve. I appreciate the help. I did a test and it should
work fine.
Ron
 
Ad

Advertisements

S

Steve Schapel

Very good, Ron. Thanks for letting us know. Best wishes with the rest
of the project.
 

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

Top