fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
accessdatabasetutorial
Home » Forms » Calculated Values in Microsoft Access Forms or Reports Video Tutorial

Calculated Values in Microsoft Access Forms or Reports Video Tutorial

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

Tags: , , , , , ,

One Response so far.

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

    […] This post was mentioned on Twitter by Erika Williamson, Ben Beitler. Ben Beitler said: RT @benbeitler Calculated Values in Microsoft Access Forms or Reports Video Tutorial http://bit.ly/gKTrNG #access database #microsoft #uibc […]