Summing Groups

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

Guest

T2032 21152415201 00B2019B $845,700.96 $3,449.14
T2046 21152515201 00B2020B $859,241.82 $62,062.00
T2058 20780135201 3231020P $4,201,305.52 $645,669.99
20780125201 N/A
20778525201 4220016C
20755525201 N/A
Totals: Total1
Total2

I have the following data on a report. the data is grouped, as you can see
there is cases where the dollor amounts are not shown. but when I sum on a
colum it includes the dollar amount for all records.For example the
$4,201,305.52 is added four times. I tried setting hide dulicates. Does
anyone know how to fix this. Thanks
 
Mike,
Looks like two problems.
One problem is that your query has not been properly "grouped", or
summarized in the query behind the report to return only one T2058 record.
Hiding dupes won't help... they still are in the recordset, and get added in
the footer.
Or, perhaps some incorrect linking to another associated table is causing
that record to quadruple... such as a link to another table that that has 4
entries associated against the T2058. I would expect that you might see
other calculations triple, or double, etc... for the same reason.
When you fix the problem, and re-run the query... T2058 should only show
up on one record line.

Also, if other records in the group are returning Null amounts, you'll
have to use the NZ() function on them to prevent your footer summing from
failing.
hth
Al Camp
 
Back
Top