Jettron said:I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
(total)
Marshall Barton said:Jettron said:I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
(total)
The usual way is to use a text box with an expression like:
=Sum([cost field])
I'm in design view of the report, where do I insert this expression?
I clicked on page footer to insert this expression & it did not work
Marshall Barton said:Jettron said:I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
(total)
The usual way is to use a text box with an expression like:
=Sum([cost field])
Marshall Barton said:Put the text box with that expression in the **report**
footer. Use the View menu if the report doesn't have the
report footer section.
--
Marsh
MVP [MS Access]
I'm in design view of the report, where do I insert this expression?
I clicked on page footer to insert this expression & it did not work
Marshall Barton said:Jettron wrote:
I have areport with a cost field that I would like to total that collum at
the end of the report. How do I do this ? do I need to create another field
(total)
The usual way is to use a text box with an expression like:
=Sum([cost field])