total multiple calcualtions in a report

  • Thread starter Thread starter Twatry
  • Start date Start date
T

Twatry

My goal is to total multiple calculation fields in a report and create a
grand total for the report and post back to my database so I can add all up
for monthly queries. i can add two caculations but when I add more fields to
the text box in the report footer it ends up blank. This is what I have so
far.


=[NO FILES $]+[EXCEL FILES $]+[ncoa qty $]+[ncoa dsf $]+[file pass $]+[file
pass2 $]+[file pass3 $]+[merge $]+[presort $]+[presort2 $]+[special
$]+[unarchiving $]+[label $]+[file pass4 $]
 
Your problem is that some of those fields are probably null (blank). If any
field in an equation expression is null, then the expression will return null.

Try using the NZ function to force the nulls to zero.

=Nz([NO FILES $],0) + Nz([EXCEL FILES $],0) + NZ([ncoa qty $],0) ...


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
That worked great, thanks!

Can the total field in my report be posted back to the database?
 
Back
Top