decimal problems in reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rong - 07 Jan 2006 05:37 GMT

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

Reply to this Message

Steve Schapel - 07 Jan 2006 05:49 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> I've got a report that multiplies items*price. I need the price carried
> out to about 6 decimals.
[quoted text clipped - 6 lines]
> Thanks,
> rong

Reply to this Message

rong - 08 Jan 2006 19:15 GMT

worked like a charm.
Thanks Steve.

Reply to this Message

Steve Schapel - 09 Jan 2006 09:04 GMT

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

Signature

Steve Schapel, Microsoft Access MVP

> worked like a charm.
> Thanks Steve.

Reply to this Message

rong - 09 Jan 2006 05:00 GMT

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

Reply to this Message