decimal problems in reports

[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

 

[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.

 

[rong]

worked like a charm.
Thanks Steve.

 

[rong]

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

 

[Steve Schapel]

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