Using Expressions - Access - Microsoft Office Online

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.

Using Expressions

Documents 1-25 of 28

Page: [1] 2 Go to previous page (disabled)

Examples of expressions

Add to or subtract from date and time values

Calculate a value using a subquery (SQL statement)

Calculate the average of the values in a field

Calculate the difference between two date or time values

Calculate the length of a text value

Calculate the serial number of the day, week, or month in a date

Combine text, number, date, and time values

Calculate the sum of the values in a field

Calculating a future or past date in Access

Calculating age from a birth date in Access

Calculating weekdays between two dates in Access

Count the number of records in an underlying query (MDB)

Examples of conditional expressions

Examples of expressions for page numbers

Examples of expressions that check for null values

Examples of expressions that look up values in other tables

Examples of expressions used in SQL statements

Examples of expressions used in update queries

Extract a part of a date or time value

Examples of referring to controls in expressions

Extract a part of a text value

Format date and time values

Joining two strings of text together in Access

Examples of using expressions with strings in Access

Documents 1-25 of 28

Page: [1] 2 Go to previous page (disabled)

Related Web Sites

» Product Support
» Microsoft.com

» Microsoft Update
» TechNet

» Office for Mac
» Office Community

Site Help | Accessibility | Contact Us | My Office.com | Office Worldwide Click here to switch to other Office Online sites worldwide