Report Footer Totals ... Won't

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

Guest

Access XP/Windows 2000 environment. Simple report, Detail section looks like
--

CATEGORY FirstNumber SecondNumber ThirdNumber

Yes, all the fields in question are contained in the data source (query) for
my report. Tried to put =Sum([FirstNumber]), =Sum([SecondNumber]),
=Sum([ThirdNumber]) in the Report Footer to get grand totals, and it
generates errors in every case. What the heck is going on? I mut have done
this umpteen times, and all of a sudden this.
 
LarryP said:
Access XP/Windows 2000 environment. Simple report, Detail section looks like

CATEGORY FirstNumber SecondNumber ThirdNumber

Yes, all the fields in question are contained in the data source (query) for
my report. Tried to put =Sum([FirstNumber]), =Sum([SecondNumber]),
=Sum([ThirdNumber]) in the Report Footer to get grand totals, and it
generates errors in every case. What the heck is going on? I mut have done
this umpteen times, and all of a sudden this.
Click to expand...


Either the report is all messed up or you are using the Page
footer intead of the Report footer.
 
While I was awaiting responses I continued to experiment, and discovered that
the errors were due to nulls in some of the numeric values in the data source
-- this even after I changed my totals formulas to Sum(Nz([FirstNumber])).
The nulls showed up very nicely as blanks in the corresponding detail rows,
but hosed up the Sum() function in the report footer. When I went back to
the source query and did my
"Nz()ing" there, the errors went away. How weird is that?

Thanks for your interest.

Marshall Barton said:
LarryP said:
Access XP/Windows 2000 environment. Simple report, Detail section looks like

CATEGORY FirstNumber SecondNumber ThirdNumber

Yes, all the fields in question are contained in the data source (query) for
my report. Tried to put =Sum([FirstNumber]), =Sum([SecondNumber]),
=Sum([ThirdNumber]) in the Report Footer to get grand totals, and it
generates errors in every case. What the heck is going on? I mut have done
this umpteen times, and all of a sudden this.
Click to expand...


Either the report is all messed up or you are using the Page
footer intead of the Report footer.
Click to expand...
 
That's very weird, so weird that I've never heard of it
happening. Since the aggregate functions (Count, Sum, etc)
all ignore rows with Null values, what you did should have
no effect, unless maybe all the records are Null in that
field (in which case the sum should be Null).
--
Marsh
MVP [MS Access]

While I was awaiting responses I continued to experiment, and discovered that
the errors were due to nulls in some of the numeric values in the data source
-- this even after I changed my totals formulas to Sum(Nz([FirstNumber])).
The nulls showed up very nicely as blanks in the corresponding detail rows,
but hosed up the Sum() function in the report footer. When I went back to
the source query and did my
"Nz()ing" there, the errors went away. How weird is that?

LarryP said:
Access XP/Windows 2000 environment. Simple report, Detail section looks like

CATEGORY FirstNumber SecondNumber ThirdNumber

Yes, all the fields in question are contained in the data source (query) for
my report. Tried to put =Sum([FirstNumber]), =Sum([SecondNumber]),
=Sum([ThirdNumber]) in the Report Footer to get grand totals, and it
generates errors in every case. What the heck is going on? I mut have done
this umpteen times, and all of a sudden this.
Click to expand...
Click to expand...
Marshall Barton said:
Either the report is all messed up or you are using the Page
footer intead of the Report footer.
Click to expand...
Click to expand...
 
Back
Top