Creating calculated fields


show more Creating calculated fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features show less
please wait ...

Creating calculated fields

Instead of having to create an expression, in a query or report, every time you want to do a calculation, you can now create a field right in your table that will perform calculations based on your data. Let's make one. I'll click on the Create tab and over here to Table. First, I'm going to put in our Company Name and I'm going to add a Currency field for the total that did owe us and I'll create another field for how much they've paid. Now, the last field I want is Amount Due.

So, what I'll do is go up to More Fields and come down here to Calculated Field and over to the right for Currency and my calculation is the Total Amount minus the Amount Paid and I'll name it Total Due. Now, when I fill this in, any amount that they owe us, note that because it's currency, it fills in dollar sign and the commas and the decimals automatically.

They've paid us $2000 and it instantly says that they owe us $8000. Please note however, that this does not work ...

Creating calculated fields
Video duration: 1m 25s 36m 35s Intermediate

Viewers:

Creating calculated fields provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 New Features

Subject:
Business
Software:
Access
Author:
please wait ...