microsoft access course - calculate report

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course - Calculate a report

microsoft access course - Calculate a report

resolvedResolved · Low Priority · Version Standard

Henrietta has attended:
Excel VBA Intro Intermediate course

Calculate a report

How do I total all the numbers in a report?

RE: Calculate a report

Hi Henrietta

To calculate all the numbers in a report for an Overall total:

In the Report's Design View

Place a text box in the Report Footer

Right click the text box and select Properties

In the Properties dialog box
Select [/b] Data[/b] And Control Source
Open the [/b]Expression Builder[/b] and enter the following formula:

=Sum([The field containing the Total])

Run the Report

Regards

Carlos


 

Access tip:

Copy a Previous Record's Values to a New Record

If you often enter the same value in one field of a table, there are two methods to save re-typing the data.

1. Use Ctrl+' (apostrophe) to repeat the value input in the previous record.

2. Change the field's DefaultValue property in Design View to the most commonly used value.

View all Access hints and tips


Server loaded in 0.09 secs.