Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access - add totals to a reports

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Access - add totals to a reports

Resolved · Low Priority · Version 2007

Reply Mon 7 Feb 2011, 16:18Delegate Frida said...

Frida has attended:
Access Introduction course

Access - add totals to a reports

Question from Intro course. How do I add totals to values in a Access report (in design view)?

For upcoming training course dates see: Pricing & availability

Reply Fri 11 Feb 2011, 09:56Trainer Anthony said...

RE: Access - add totals to a reports

Hi Frida, thanks for your query and apologies for the delay in replying.

Open your report in Design view and add a text box control to the Report Footer. It's important that you put the field here and not, say, in the page footer; the Sum function needs to use all records in the calculation and will only do so when it is in the report header or footer. Open the control's Properties, select the Data tab, and enter an expression for the text box's Control Source property such as "=Sum([myfield])". Obviously, replace "myfield" with the field from your table. Then view the report. The sum should be in place

Hope this helps!

Anthony

Thu 17 Feb 2011: Automatically marked as resolved.

Access articles

· Making Figures Talk For Themselves Thanks To Access
· Microsoft Access Training Unleashes the Power of the Pivot Table
· An Introduction To Queries In Access
· How To Make One Combo Show Values Determined By Another Combo In Access
· Don't Do It By The Book, Access Your Important Contacts In An Easy To Use Database

Please browse our web site to find out more about
access/courses and other Microsoft training courses.

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips