sum a report

  • Thread starter Thread starter pat67
  • Start date Start date
P

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?
 
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?
Click to expand...

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
 
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?
Click to expand...

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
Click to expand...

thanks
 
Back
Top