Calculated Values in Microsoft Access Forms or Reports Video Tutorial

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).

One Reply to “Calculated Values in Microsoft Access Forms or Reports Video Tutorial”

Leave a Reply

Your email address will not be published. Required fields are marked *