rounding

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

 

[Joseph Meehan]

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.

No, but anytime you are doing rounding, you can get a penny off.

 

[SAC]

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

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

Thanks.

 

[Joseph Meehan]

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

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

Thanks.

It is the nature of rounding. If you round a group of numbers then
total them and then if you total the original group, they will not always be
the same.

There are a number of different ways to round. Maybe if you give a
little more information about the particular case, I may be able to help.

 

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

 

[SAC]

Thanks!

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)