Queries IV: Use functions and calculated fields in your queries
Learn how to use functions and calculated fields in your queries. Access 2007 provides built-in functions that sum, count, and average data. You can also use expressions to create calculated fields — fields that exist only when you run your query.
About this course
This course includes:
One session for hands-on experience. The practice requires Access 2007.
A Quick Reference Card you can take away from the course.
After completing this course you will be able to:
Create a totals query.
Use expressions to create calculated fields.
Use parentheses to control operator precedence.
Include or exclude null values from a record set.