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