adding summary in report footer?

[helen]

Hi
This may sound silly, but can someone please tell how to add summary in
report footer in Access? i am having so much trouble trying to add a sum.

I am trying to to add a total amount using the following:

=sum([cost per day]*[days hired])

I don't seem to be able to type this in the report footer. Do we have set a
formula in Table or quries first?

 

[Ofer Cohen]

Hi Helen,

Create a TextBox in the Report footer and in the TextBox control source
property add the text

=sum([cost per day]*[days hired])

Also, the two fields above ([cost per day],[days hired]) need to be names of
the field in the table

 

[Duane Hookom]

Also, if you have already tried this and failed, I expect you added your text
box in the Page Footer rather than the Report Footer.

--
Duane Hookom
Microsoft Access MVP

Hi Helen,

Create a TextBox in the Report footer and in the TextBox control source
property add the text

=sum([cost per day]*[days hired])

Also, the two fields above ([cost per day],[days hired]) need to be names of
the field in the table

--
Good Luck
BS"D

Hi
This may sound silly, but can someone please tell how to add summary in
report footer in Access? i am having so much trouble trying to add a sum.

I am trying to to add a total amount using the following:

=sum([cost per day]*[days hired])

I don't seem to be able to type this in the report footer. Do we have set a
formula in Table or quries first?