RE: Access - Sum Totals

Dear Andrew

Thank you for attending Access Introduction course!! I hope you enjoyed the course and benefited from it.

In Intermediate Access we cover performing calculations on using fields in Queries as well as Forms and Reports.

In table you cannot perform calculations. What you want seems to be more appropriate when you are dealing with forms as they are the objects that the end user is more likely to be using.

In Advanced level we talk about Pivot Table views which should also be able to get more complicated summarization for you.

Please click on the below mentioned links for further information on Access Intermediate and Advanced Course.
http://www.microsofttraining.net/access-courses-in-london-2003-intermediate.php

http://www.microsofttraining.net/advanced-microsoft-access-in-london-2003.php

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007