Access

Hi Arabella, Thank you for your post, in answer to your question, you could create a query;
To create the calculation you are looking for. Create a new query in design view and add in the fields you need to total. Then on the title bar, you will see the sum character, the Greek letter sigma.
If you click on that a new field will appear on your query labeled total. If you click in that field you will see the options availible. For totalling a column you should use Sum. To verify the output just click on the Run query button and you will see the total output. However this does not show the column with the total at the bottom or top as in Excel, what you need to do, is create a report and have your field total created in this, (its a shame you are not using 2007, there is a brand new facility for column totals in a table,) but that aside, to create a calculated field in a report, change to design view on the report, create a new control using the toolbox, and then right click on the new field and choose Properties, in the properties box that opens, in the source row, insert the formula =sum[table name.field name], substituting the table name and field name exactly as in your database; close the properties box, and view your report in print view. You will see the total at the bottom of your column of figures. I hope that has helped, best regards Pete.