microsoft access 2002 training - Access - Calculation of totals

Hi Adrienne

Thank you for your question regarding calculating totals at the bottom of a column.

In Access, this is not possible in the usual way. In a Table or a query, you cannot SUM the column (field). However, you can do it in a report.

To do this, simply create a columnar report using the wizard.
Next you will need to add a control to the bottom of the report. I suggest doing it in the PAGE FOOTER area. If you need to make more space, simply drag the edge of the area down.

Select the TEXT BOX control from the toolbox, and drag an area where you would like the TOTAL to appear.

Once you have done that, now you need to enter some code to make the calulation work. For example, if the field name is AMOUNT, then you would write the following:

=SUM([AMOUNT])

This will add together all the results on that page for the AMOUNT field. If for any reason you get a VALUE or NAME error, try moving the caluclation control to the REPORT FOOTER area. also check the spelling of the field name you typed into the text box.

Let us know how it goes, and if you have any further questions, please feel free to post them on our forum.

Regards

Richard
Microsoft Office Specialist