Join Alicia Katz Pollock for an in-depth discussion in this video Creating calculated fields, part of Access 2010 New Features.
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 with date fields, because the data…would be constantly changing at every moment.…
- Working with Application Parts
- Implementing the Table Tools ribbon
- Using Quick Start and calculated fields
- Designing with Layout View formatting tools
- Taking advantage of enhancements to the Conditional Formatting feature
- Automating with macros
- Working with external data
- Integrating SharePoint publishing
Skill Level Intermediate
Q: My macro isn't running correctly. I followed along with the author and I'm not receiving an error message, but the actions are performed correctly.
A: There are several possible reasons why a macro would malfunction. Make sure that the macro is written correctly. Capitalization and punctuation matters. Also make sure to click in all the same places when recording the macro. With enough practice, building macros will become more routine, and spotting errors will becoming easier.