Queries IV: Use functions and calculated fields in your queries

Learn how to use functions in 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.

Start course button

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.

Before you begin

Topics in this section

  1. Add calculations to your queries

  2. Create a calculated field

  3. Operators for use in calculations

  4. Operator precedence

  5. Use dates in calculations

  6. Use null values in calculations

  7. Practice

  8. Quick reference card

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language