sum a report

[pat67]

On a form if i want to sub a field i just do =Sum([Field]) and it sums
the field. On a report, this does not work. How do I sum a field on
the bottmom of a report?

 

[John W. Vinson]

On a form if i want to sub a field i just do =Sum([Field]) and it sums
the field. On a report, this does not work. How do I sum a field on
the bottmom of a report?

Put a textbox with a control source of =Sum([Field]) in the REPORT footer -
not the PAGE footer! - and it will work just like on a form. You may need to
select View from the menu and select Report Footer to make it visible.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[pat67]

On a form if i want to sub a field i just do =Sum([Field]) and it sums
the field. On a report, this does not work. How do I sum a field on
the bottmom of a report?

Put a textbox with a control source of =Sum([Field]) in the REPORT footer -
not the PAGE footer! - and it will work just like on a form. You may needto
select View from the menu and select Report Footer to make it visible.
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com

thanks