How To Use Calculation Fields In Microsoft Access

Once you've created table and queries in Microsoft Access you might want to use calculation fields in your data. A calculation field is a field derived from data in one or more existing table fields. However a calculation field cannot be added to a table, but it can be added to a query. You can then base any forms or reports on the query rather than the table. This article summarises how to create a calculation field in a query by describing two examples; a bonus calculation and an age calculation.

The full article appears here:
http://www.microsofttraining.net/article-1553-how-use-calculation-fields-in-microsoft-access.html

Regards,
The Microsoft Training Blog Team
http://microsoft-training.blogspot.com