Round Value in a report?

G

Guest

Hello!
I have a question about rounding. My report show a value, I use format
properity.
Format: #.###;"";""
Decimal Places: 3

In the report, the actually value is ".47152", and it displayed ".472". Now
I don't need round it(to display ".471". Is any way to do that? How can I do
that?
Thank you very much.

Fox
 
A

Al Camp

Fox,
I'm sure there may be a simpler way, but... (Value = .47152)

Int( [Value] x 1000) / 1000
should do 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

Total and Round problem? 2
Number Field Automatically Rounding Decimals 3
dynamic adaptive / variable report field format 1
Always round up in calculation 2
rounding is ignored in calculated control 4
How can I round a number to 2 significant figures 2
Rounding up in report?? 4
Currency format with 2 decimals not showing on report 2

Top