Calculate a value using a subquery (SQL statement) - Access

Click here to switch to other Office Online sites worldwide

United Kingdom (change) | All Microsoft Sites

	Microsoft Office Access

Search

	Word 2007 Outlook 2007
Get up to speed

	Get your business online Get help using Office 2007
Your business

	Check for free updates
Office updates

Microsoft Office Access

» Access Home

Product Information

» Overview

» Top 10 Benefits

» See it in Action

» Compare Features

» Try Now

» Buy Now

Help and How-to

» Access 2007 Help

» Access 2003 Help

» Access 2002 Help

» Access 2000 Help

Choose your version

Training

» Access 2007 Training

» Access 2003 Training

» Access 2007 Demos

» Access 2003 Demos

Templates

» Templates for Access

Support and Feedback

» Product Support

» Send Us Your Comments

Technical Resources

» Developer Center

» Office Resource Kit

Additional Resources

» Office Marketplace

» Discussion Groups

» Access Solutions

» Access MVPs

Home > Products > Access > Access 2003 Help and How-to > Expressions > Using Expressions

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Printer-Friendly Version

Calculate a value using a subquery (SQL statement)

Applies to: Microsoft Office Access 2003

You can use these expressions in a calculated field in a query.

Expression	Description
Category: (SELECT [CategoryName] FROM [Categories] WHERE [Products].[CategoryID] = [Categories].[CategoryID])	Displays in the Category field the CategoryName, if the CategoryID from the Categories table is the same as the CategoryID from the Products table.
AveragePrice: (SELECT AVG([UnitPrice]) FROM [Products] WHERE [Products].[Salesman] = [Categories].[Salesman])	Displays in the AveragePrice field the average of the values in the UnitPrice field for records, where the Salesman from the Categories table is the same as the Salesman in the Products table.