Queries are used in Access to specifically merge the information that is currently needed from the database tables. Often, not the basic data, but calculated information is needed. For example, if you want to output a person's age, not the date of birth. In such a case, add a calculated field to the query.
To acces the videos for this Special Topic you must have subscribed to Access !
Access 2016
Calculated Fields:
This video will show you how to add calculations to your queries.
(5 Min.)
Access 2013
Calculated Fields:
This video will show you how to add calculations to your queries.
(5 Min.)
Access 2010
Calculated Fields:
This video will show you how to add calculations to your queries.
(5 Min.)
Access 2007
Calculated Fields:
This video will show you how to add calculations to your queries.
(5 Min.)