A quick video tutorial showing how to carry out basic calculations in a form though it can be applied to a report too.
It demonstrates using the Expression Builder tool which is useful for picking and choosing functions, setting operators and locating other objects from other forms, report, queries and tables.
A new look in Microsoft Access 2010 is the Expression Builder tool and has essentially the same functionality as the old one. Also, you can now even store a calculated field into a table for the first time.
Finally, if your are going to calculate in a query, you do not start with the ‘=’ sign as demonstrated with a form (and for a report).