truncating values in sum on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a fairly simple report which is providing odd results. I have a
report with 2 levels of groups and a qualtity - contribution. I would like
to total contribution in the footer of both groups. I am using the formula
=sum([contribution]). The fields in the data base are formatted currency and
the fields in the report are formated currency. The result I get is the sum
of the integer portion of the individual contributions, not the actual sum.
Any ideas?
 
Yes,

I have all the fields in the query and the report set as currency -
including the totals which are providing the incorrect result.

Cindy

Allan Murphy said:
Cindy

Set the FORMAT property of the total box to CURRENCY

--
Allan Murphy
Email: (e-mail address removed)

Cindy Buck said:
Hi,

I have a fairly simple report which is providing odd results. I have a
report with 2 levels of groups and a qualtity - contribution. I would like
to total contribution in the footer of both groups. I am using the formula
=sum([contribution]). The fields in the data base are formatted currency and
the fields in the report are formated currency. The result I get is the sum
of the integer portion of the individual contributions, not the actual sum.
Any ideas?
Click to expand...
Click to expand...
 
On Mon, 13 Jun 2005 09:50:01 -0700, "Cindy Buck" <Cindy
Hi,

I have a fairly simple report which is providing odd results. I have a
report with 2 levels of groups and a qualtity - contribution. I would like
to total contribution in the footer of both groups. I am using the formula
=sum([contribution]). The fields in the data base are formatted currency and
the fields in the report are formated currency. The result I get is the sum
of the integer portion of the individual contributions, not the actual sum.
Any ideas?
Click to expand...

The Currency *FORMAT* merely controls how the information is
displayed, not what's stored. I'm guessing that the datatype of this
field in the underlying table is a Number, Long Integer - the default
size of a Number field. Long Integers are, by definition, whole
numbers which do not support fractions.

A Currency *datatype* - it's one of the selections along with Number,
Text, Date/Time etc. in table design mode - will be better; it is a
huge scaled integer with exactly four decimal places and no roundoff
error.

John W. Vinson[MVP]
 
Thanks!

That was the problem. I am getting the data from a source on a 3000 so I
used the val function and poof - correct sums.

Thanks for responding to my post - it really helped!
 
Back
Top