Report Design

  • Thread starter Thread starter Jessica
  • Start date Start date
J

Jessica

I've created a box to calculate the grand total for a
field called total. It runs and calculates, however, it
is a penny off. I've set all the fields for 2 decimal
places. Am I missing something?
 
You are probably rounding up or down.
This is from Access help

The default type of Number is a "Long Integer" - which IS
an integer,
that is, a whole number.

Rounds a number to a specified number of digits.

Syntax

ROUND(number,num_digits)

Number is the number you want to round.

Num_digits is the number of digits you want to round to.
Negative rounds to the left of the decimal point; 0 (zero)
rounds to the nearest integer.

_____________

ROUNDDOWN
Rounds a number down, toward 0 (zero).

If this function returns the #NAME? error value, you may
need to install msowcf.dll.

Syntax

ROUNDDOWN(number,num_digits)

Number is any real number that you want rounded down.

Num_digits is the number of digits you want to round to.
Negative rounds to the left of the decimal point; 0 (zero)
or omitted rounds to the nearest integer.
___________

ROUNDUP
Rounds a number up, away from 0 (zero).

If this function returns the #NAME? error value, you may
need to install msowcf.dll.

Syntax

ROUNDUP(number,num_digits)

Number is any real number that you want rounded up.

Num_digits is the number of digits you want to round to.
Negative rounds to the left of the decimal point; 0 (zero)
or omitted rounds to the nearest integer.


Jim
 
Back
Top