Totalling Across The Page

  • Thread starter Thread starter Frank Wagner
  • Start date Start date
F

Frank Wagner

I have built a report based on a CrossTab query. I've
been able to total the columns down the page with a
control that has the formula " =Sum(Detail Control Name
for that Column)".

When totalling across the page, I have a number of
columns to add together. Some of the values in the
CrossTab query are blank. When I place a control on the
right side of the page with the Formula " = Column1 +
Column 2 + Column3 ", the control works for those rows
that have no blanks, but does not work for the other rows.

I am familiar with VBA Coding, but have never used it on
reports.

Any help would be appreciated

Frank Wagner
 
Frank said:
I have built a report based on a CrossTab query. I've
been able to total the columns down the page with a
control that has the formula " =Sum(Detail Control Name
for that Column)".

When totalling across the page, I have a number of
columns to add together. Some of the values in the
CrossTab query are blank. When I place a control on the
right side of the page with the Formula " = Column1 +
Column 2 + Column3 ", the control works for those rows
that have no blanks, but does not work for the other rows.

I am familiar with VBA Coding, but have never used it on
reports.

Any help would be appreciated

Frank Wagner
Click to expand...

Use...

=Nz(Column1, 0) + Nz(Column2, 0) etc...
 
It is normally easier to do this in the crosstab by creating a new Row
Heading that Sums a field or expression.
 
Back
Top