Round a number/ Access 2007

[Abay]

Hello,

I am trying to round the results of a calculation without success.

I would like the result of the following to round up to 2 decimal places.

Dgst - dlinetot / 105 * 5

Dgst is defined as a number with 2 decimal places
Dlinetot is defined as a number with 3 decimal places

The result should be 4.67 but shows 4.66

I tried using the Round function (using the sytax from access help),as
follows:

round (dgst = dlinetot / 105 * 5 [,2]) or
round (dgst=dlinetot/105 * 5, 2) and get an error msg "expected end of
statement"

I know I am doing something wrong .. so any help with this would be most
appreciated.

Abay

 

[Stuart McCall]

Hello,

I am trying to round the results of a calculation without success.

I would like the result of the following to round up to 2 decimal places.

Dgst - dlinetot / 105 * 5

Dgst is defined as a number with 2 decimal places
Dlinetot is defined as a number with 3 decimal places

The result should be 4.67 but shows 4.66

I tried using the Round function (using the sytax from access help),as
follows:

round (dgst = dlinetot / 105 * 5 [,2]) or
round (dgst=dlinetot/105 * 5, 2) and get an error msg "expected end of
statement"

I know I am doing something wrong .. so any help with this would be most
appreciated.

Abay

Your 2nd try with the round function almost had it. Try:

dgst = round(dlinetot/105 * 5, 2)

This assigns the result from the round function to dgst.

 

[John W. Vinson]

Dgst - dlinetot / 105 * 5

Dgst is defined as a number with 2 decimal places
Dlinetot is defined as a number with 3 decimal places

The result should be 4.67 but shows 4.66

4.66 is correct; Access uses "Banker's Rounding". A value ending in 5 will
round to the nearest *even* number, up or down, rather than always rounding
up; this gives a more accurate result, since the average of a large set of
numbers will be closer to the average of the same set, rounded. The "rounding
up" algorithm will make the results creep up.

 

[Abay]

Thank you John for the information .. good to know.

Abay

 

[Abay]

Many thanks Stuart ... it works of course, yeah!
Really appreciate your help.

Abay

Hello,

I am trying to round the results of a calculation without success.

I would like the result of the following to round up to 2 decimal places.

Dgst - dlinetot / 105 * 5

Dgst is defined as a number with 2 decimal places
Dlinetot is defined as a number with 3 decimal places

The result should be 4.67 but shows 4.66

I tried using the Round function (using the sytax from access help),as
follows:

round (dgst = dlinetot / 105 * 5 [,2]) or
round (dgst=dlinetot/105 * 5, 2) and get an error msg "expected end of
statement"

I know I am doing something wrong .. so any help with this would be most
appreciated.

Abay

Your 2nd try with the round function almost had it. Try:

dgst = round(dlinetot/105 * 5, 2)

This assigns the result from the round function to dgst.