Design reports with formulas

From: kleivakat (kleivakat_at_discussions.microsoft.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 14:43:03 -0700

I created a report that totals three different types of space in two
different buildings. I was able to create subtotals for each type of space
in each building, and a grand total of each different type of space in both
buildings. Now I want to add a "Grand Total", which would be a number adding
up the three different types of space in both buildings. I can't get the
formula right.

I created a text box at the bottom of the report (design view) in the report
footer section, but can only get the formula to show on the report in the
preview mode. I tried this: =sum([OfficeSF]+[StorageSF]+[BackOfficeSF]),
which I hoped would give me the grand total. All that shows is the written
formula. Thanks for any help.

Loading