adding summary in report footer?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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


Ofer Cohen said:
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


helen said:
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?
Click to expand...
Click to expand...
 
Back
Top