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

This entry was posted in Forms, MS Access, Reports, Tables, Utilities and tagged , , , , , . Bookmark the permalink.

One Response to Calculated Values in Microsoft Access Forms or Reports Video Tutorial

  1. Pingback: Tweets that mention Calculated Values in Microsoft Access Forms or Reports Video Tutorial | Access Database Tutorial -- Topsy.com

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.