answersLogoWhite

0


Best Answer

It will depend how you have the report set up, but if you have a field like [Cost] and you want to collect the total, then something like this should work for you.

  • Create a new textbox in the footer field of the section you want to total
  • Set the control source to "=Sum([Cost])" (no quotes)
  • Make sure to set "Running Totals" in the textbox options to "No"
User Avatar

Wiki User

14y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do You create a 'total' label in a Microsoft Access Report?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is Microsoft Office 97 compatible with Windows XP?

Yes, it works fine except for the address label merge feature. When you try to create or access a database of addresses, it gives a "Out of Memory" error. You can't even create a database from scratch in XP


What is a label in Microsoft access?

It labels items on a chart. Category labels go across the bottom, on the horizontal or X-Axis. Values are normally on the Y-Axis. So if it were a bar chart, a category would have a bar coming from the X Axis and its value would be measured by what point on the Y-Axis it is equal to. The category labels tell us what that bar represents, like sales or profits or a particular year etc.


Does Microsoft Office have label printer on it?

Using various Microsoft Office products you can print labels, particularly Microsoft Word. It can be done to different kinds of label printers.


What are element call in a form in access?

Control: Any element on a form or report such as a label, text box, line, or combo box. Controls can be Bound, Unbound, or Calculated. This answer applies to MS Access.


Where can someone download a copy of the Avery label maker?

Avery's website provides downloadable templates that lets you create labels with Microsoft Word. You can also download Avery label maker from sites like Afreecodec and WinSite,


How do you label machines and equipment to create a safe working environment?

How to label machines and equipment to create a safe working environment


What is every element on a form called?

Control: Any element on a form, or report such as a label, text box, line, or combo box. Controls can be bound, unbound, or calculated. This answer applies to Access


What makes a poor PowerPoint presentation?

function of microsoft exel and label


Can you draw and label the parts of Microsoft Word 2007?

No drawings are possible.


What group in word do you click to print a mailing label?

When using Microsoft Word to print mailing labels, click on the create labels button on the mailings tab in the create group tab. Once that is done click on start mail merge to complete the process.


How do you send a xbox360 to Microsoft?

Call 1-800-4MY-XBOX Microsoft will send you a prepaid shipping label, and provide the packaging.


Can you make sub folders within a 'Label' in Gmail?

Yes you can make sub-folders within a Label. A label is a folder which can be used for categorization. You can create a label within a label in settings.