rounding

S

SAC

I have a report that's off by a penny.

I formated each field as currency in the query, do I need to also round each
field in the query and the report?

Thanks.
 
S

SAC

This is not good. Is this Access or other programs too?

If others, then how do boooks ever balance using a computer?

Thanks.
 
V

Van T. Dinh

Do you mean you have some sort of sun value and this is
off by a penny (or more) when you manually add up the
components?

The format in the Query / Report / etc... only affect what
you see, not the actual values. Thus, for example, you
may have some thing like:

Value Formatted
1.2751 1.28
1.2751 1.28

Qhen you add the 2 values up (2.5502) which will be
formatted to 2.55 and this is different from the (manual)
sum of the 2 formatted "number" components.

If this is the case you need to round the components first.

HTH
Van T. Dinh
MVP (Access)
 
S

SAC

Thanks!

Van T. Dinh said:
Do you mean you have some sort of sun value and this is
off by a penny (or more) when you manually add up the
components?

The format in the Query / Report / etc... only affect what
you see, not the actual values. Thus, for example, you
may have some thing like:

Value Formatted
1.2751 1.28
1.2751 1.28

Qhen you add the 2 values up (2.5502) which will be
formatted to 2.55 and this is different from the (manual)
sum of the 2 formatted "number" components.

If this is the case you need to round the components first.

HTH
Van T. Dinh
MVP (Access)
Click to expand...
 
Top