Don't Round Total

[Johnny]

I have a report that is giving a total calculation of several currency
fields. The currency fields are exactly the way they should be, example:
$1.01. There is no additional numbers other than the last two past the
decimal point. However, my calculation total is doing a round up and round
down situation. Don't know why, but I don't want it to round, I want an
exact total for $1.01+$.34+$2.14=$3.49, not $3.50 or in noncurrency form it
shows 3.4998.

Any clues how to fix this? It is a very simple report calculation.

Thanks.

 

[Allen Browne]

If you open the table in design view, what data type is the field?
Does it show Currency in the Data Type column?
Or does it show Number (possibly with Currency down in the Format property)?

Currency will add correctly.
Number (Single or Double) will not.

If it is currency, some of the other figures do have significant figures
that are fractions of a cent, even if they are not displayed that way.

 

[Johnny]

The fields are all currency in the table, very basic. Where might I have a
possible are to search to find fractions of a cent, however, that does make
the most sense.

Thanks,
Johnny

 

[Allen Browne]

Temporarily set the Format property to:
$#,##0.0000

You can do that for the Format property of the text box, or the Format
property of the field in the query or the table.

 

[Johnny]

Thank you for your help. I was able to trace down the pricing issue as to
how it is entered in the form with 4 digits after the period. Helped me to
understand it immensely. The table is set for currency so it was converting
it.