Grand Total for a calculated column - Access 2007

  • Thread starter Thread starter PanoramaB
  • Start date Start date
P

PanoramaB

I've developed a report with a variety of calculated columns. The last
column (total)is the sum of a column that had a value and another column that
contains a calculated value. The last column (total) contains the correct
calculated value. I want to sum the last column (total) to show the grand
total of all values in this column at the bottom of the page. My data looks
like this:

Grand Prop Rev Per Total
$2,500 $1,000 $3,500 (=(grnd prop+rev per))
$1,000 $3,000 $4,000

grand total $7,500 (this is what I want to
see)

I already have a grouping and totals for the columns that contained values
(not calculated values). I have tried adding an unbound box in the Report
Footer and creating an expression (=sum(total)) but it won't total create the
grand total at the bottom of the report. Any ideas?
 
PanoramaB said:
I've developed a report with a variety of calculated columns. The last
column (total)is the sum of a column that had a value and another column that
contains a calculated value. The last column (total) contains the correct
calculated value. I want to sum the last column (total) to show the grand
total of all values in this column at the bottom of the page. My data looks
like this:

Grand Prop Rev Per Total
$2,500 $1,000 $3,500 (=(grnd prop+rev per))
$1,000 $3,000 $4,000

grand total $7,500 (this is what I want to
see)

I already have a grouping and totals for the columns that contained values
(not calculated values). I have tried adding an unbound box in the Report
Footer and creating an expression (=sum(total)) but it won't total create the
grand total at the bottom of the report.
Click to expand...


The aggregate functions (Count, Sum, etc) are not aware of
controls in a form/report. They only operate on fields in
the form/report's record source table/query.

Change the grand total expression to something more like:

=Sum([Grand Prop] + Nz([Rev Per], 0))
 
Back
Top