Report totals

  • Thread starter mbr96 via AccessMonster.com
  • Start date
M

mbr96 via AccessMonster.com

I have a control on the detail section of a report with the control source
set as
=([TotCYP1]+[TotCYP2]+[TotCYP3]+[TotCYP4]+[TotCYP5]+[TotCYP6]+[TotCYP7]+
[TotCYP8]+[TotCYP9]+[TotCYP10]+[TotCYP11]+[TotCYP12]+[TotCYP13])

Another control in the report footer for the sum of the first field I have
control source as
=Sum([TotCYP1])+Sum([TotCYP2])+Sum([TotCYP3])+Sum([TotCYP4])+Sum([TotCYP5])
+Sum([TotCYP6])+Sum([TotCYP7])+Sum([TotCYP8])+Sum([TotCYP9])+Sum([TotCYP10])
+Sum([TotCYP11])+Sum([TotCYP12])+Sum([TotCYP13])

Now the kicker: The sum of the numbers in the detail doesn't equal the
footer. Off by about 1%. I didn't think I should paste the numbers (26 rows)
but can if it helps.

Data type is decimal with zero places (no fractions, I supposed I should use
Long Integer). Still, any help please?

Mbr96
 
M

mbr96 via AccessMonster.com

I think I got it - I built the sum for the detail section in the query, then
simply summed the detail section in the footer (sum expression in report
footer was easier). That did the trick.

Thanks anyway team! A much appreciated service.

MBR96
I have a control on the detail section of a report with the control source
set as
=([TotCYP1]+[TotCYP2]+[TotCYP3]+[TotCYP4]+[TotCYP5]+[TotCYP6]+[TotCYP7]+
[TotCYP8]+[TotCYP9]+[TotCYP10]+[TotCYP11]+[TotCYP12]+[TotCYP13])

Another control in the report footer for the sum of the first field I have
control source as
=Sum([TotCYP1])+Sum([TotCYP2])+Sum([TotCYP3])+Sum([TotCYP4])+Sum([TotCYP5])
+Sum([TotCYP6])+Sum([TotCYP7])+Sum([TotCYP8])+Sum([TotCYP9])+Sum([TotCYP10])
+Sum([TotCYP11])+Sum([TotCYP12])+Sum([TotCYP13])

Now the kicker: The sum of the numbers in the detail doesn't equal the
footer. Off by about 1%. I didn't think I should paste the numbers (26 rows)
but can if it helps.

Data type is decimal with zero places (no fractions, I supposed I should use
Long Integer). Still, any help please?

Mbr96
Click to expand...
 
Top