sum a report

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

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top