Totals not working

  • Thread starter Thread starter cp2599
  • Start date Start date
C

cp2599

I have a yearly report whose detail contains monthly summations from
the database (=DSUM...). The report footer contains a total by
summing all the individual monthly summations
(=intTot1+intTot2+intTot3 ... +intTot12). The DSUM is working;
however, the total in the footer is not. Any suggestions on what I'm
doing wrong?

The detail and total fields are defined as General Number on the
report.
 
Typically reports are bound to queries/tables so you can create sums and
other aggregates in header and footer sections. DSum() and other domain
aggregate functions should be avoided if possible.

Can you tell us something about your report and why you think you need to
use DSum()s rather than summing values from a Record Source?
 
I have a spreadsheet of statistics (15 x 12) each cell having a
different set of criteria to create a total.
 
Access isn't a spreadsheet. It's a relational database. Access has fields and
records, not cells.

You haven't really answered my question:
 
Back
Top