Rounding Number on a report

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

In the query design I have the expression ([a]/)*[c]). This comes out to
a number with 10 decimal places to the right and I would like the expression
to be rounded to 2 places. Any suggestions?
 
If you just need to *display* the number as 2 places, open the report in
design view, and set these properties for the text box:
Format Fixed
Decimal Places 2

If you actually need to round the expression to 2 places (so it adds up
correctly), use:
=Round(([a] / ) * [c], 2)

More information about rounding:
http://allenbrowne.com/round.html
 
Thanks for your help.

Allen Browne said:
If you just need to *display* the number as 2 places, open the report in
design view, and set these properties for the text box:
Format Fixed
Decimal Places 2

If you actually need to round the expression to 2 places (so it adds up
correctly), use:
=Round(([a] / ) * [c], 2)

More information about rounding:
http://allenbrowne.com/round.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Mike said:
In the query design I have the expression ([a]/)*[c]). This comes out
to
a number with 10 decimal places to the right and I would like the
expression
to be rounded to 2 places. Any suggestions?
Click to expand...
Click to expand...
 
This helped me alot...

Thanks!
Boss

Allen Browne said:
If you just need to *display* the number as 2 places, open the report in
design view, and set these properties for the text box:
Format Fixed
Decimal Places 2

If you actually need to round the expression to 2 places (so it adds up
correctly), use:
=Round(([a] / ) * [c], 2)

More information about rounding:
http://allenbrowne.com/round.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Mike said:
In the query design I have the expression ([a]/)*[c]). This comes out
to
a number with 10 decimal places to the right and I would like the
expression
to be rounded to 2 places. Any suggestions?
Click to expand...
Click to expand...
 
Back
Top