Rounding Number on a report

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

 

[Allen Browne]

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

 

[Golfinray]

Round([tablename.fieldname],2)

 

[Mike]

Thanks for your help.

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.

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?

 

[Boss]

This helped me alot...

Thanks!
Boss

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.

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?