Sum Doubles

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

Guest

I have a select query with a single number field which I am trying to sum.
The query returns 2 records numeric values are 6 and 38, which is correct.
When I select totals and choose sum for the number field instead if getting
44 I get 88. if I create a seperate query (identicle) and chose first query
and preform the same action I get 44. Confused

In testing the original query I duplicated the number field ( sumof: ) and
summed it returned 6 ( first field Grouped by) 12 sum of: field like wise 38
first and 76 for the summed.??
 
Dan:

I had something similar happen to one of my reports. Double-check by making
sure you are not somehow running the summing twice (without zeroing the
summing field or variable). You might also try adding each record's to a
report variable as the report is being populated, then use the variable for
the sum field's value.

John H W
 
Back
Top