Summing calculated fields in a report - How to?

  • Thread starter Thread starter Don Seckler
  • Start date Start date
D

Don Seckler

I have a report that shows copies of a magazine that are sold, the
price they're sold at and the total dollars for those copies.

The total field is a calculation of the copies field times the price
field.

How do I total the total field. I've been trying showing running
totals, but that puts a running title after each row. I just want one
grand total to show so I can use it When I make this report a sub
report of a nother report.
 
Duane,

If I use =Sum ([Copies] * [price]), Shoul {copies] be the name of that
text box or should I use the control source of the text box?

Thanks for your help

Don


Duane Hookom said:
Use something like:
=Sum([Copies] * [Price])

--
Duane Hookom
Microsoft Access MVP


Don Seckler said:
I have a report that shows copies of a magazine that are sold, the
price they're sold at and the total dollars for those copies.

The total field is a calculation of the copies field times the price
field.

How do I total the total field. I've been trying showing running
totals, but that puts a running title after each row. I just want one
grand total to show so I can use it When I make this report a sub
report of a nother report.
Click to expand...
Click to expand...
 
You should substitute the name(s) from your table/query.
Hope this helps.
Fons
-----Original Message-----
Duane,

If I use =Sum ([Copies] * [price]), Shoul {copies] be the name of that
text box or should I use the control source of the text box?

Thanks for your help

Don


"Duane Hookom" <duanehookom@NO_SPAMhotmail.com> wrote in
message news: said:
Use something like:
=Sum([Copies] * [Price])

--
Duane Hookom
Microsoft Access MVP


Don Seckler said:
I have a report that shows copies of a magazine that are sold, the
price they're sold at and the total dollars for those copies.

The total field is a calculation of the copies field times the price
field.

How do I total the total field. I've been trying showing running
totals, but that puts a running title after each row. I just want one
grand total to show so I can use it When I make this report a sub
report of a nother report.
Click to expand...
Click to expand...
.
Click to expand...
 
Back
Top