Rounding

[Jeff Kaufman]

I am currently using Microsoft Access 2003... In my query I have a
calculation on two existing fields from a table. How to I have the results
of this calculation return only 2 decimal places in the result?

 

[Tom Wickerath]

Hi Jeff,

You can use the built-in Round function to round to two decimal places, if
"Banker's Rounding" will suit your needs. This is the type of rounding that
is applied with the Round function. You can Google or Bing the term Bankers
Rounding to learn more about this method.

In the query field row, you can add the Round function something like this:

ColumnAlias: Round(YourCalculationHere, 2)


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[kc-mass]

Straight from the help file:

Round(expression [,numdecimalplaces])

Regards

Kevin

 

[Tom Wickerath]

PS. Here is some additional information on rounding, in the event that the
built-in Banker's Rounding (ie. the Round function) is not suitable for your
needs:

http://my.advisor.com/doc/08884


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

Hi Jeff,

You can use the built-in Round function to round to two decimal places, if
"Banker's Rounding" will suit your needs. This is the type of rounding that
is applied with the Round function. You can Google or Bing the term Bankers
Rounding to learn more about this method.

In the query field row, you can add the Round function something like this:

ColumnAlias: Round(YourCalculationHere, 2)


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

:

I am currently using Microsoft Access 2003... In my query I have a
calculation on two existing fields from a table. How to I have the results
of this calculation return only 2 decimal places in the result?