Skip to search results
PRODUCT
Office.com results
Examples of expressions
Article This article provides examples of expressions. An expression is a combination of mathematical or logical operators, constants, functions, table fields, controls...
Access 2007
Create conditional (Boolean) expressions
Article This article explains how to create conditional (also known as Boolean) expressions. A conditional expression evaluates to either true or false, and it then ret...
Access 2007
Guide to expression syntax
Article Show All Hide All When you use Microsoft Office Access 2007, you will encounter situations in which you need to work with values that do not reside directly in ...
Access 2007
Why does Access want me to enter a parameter value?
Article Learn why Access displays the Enter Parameter Value dialog box.
Access 2010, Access 2007
Create a text box that looks up a value in a table
Article When you design a form, you may want to display a value from a table or query other than the one that your form is bound to. For example, suppose that you have ...
Access 2007
Table of operators
Article Use operators in Access expressions to specify what kind of operation to perform, such as add, multiply, compare, or concatenate.
Access 2007
Add a date or time stamp to new records
Article In some Microsoft Office Access tables, it is important to keep track of the date or the date and time when a new record is added. This is often referred to as ...
Access 2007
Introduction to expressions
Article An expression is like an Excel formula: it may include constants, variables, and functions. You can use expressions with most database objects.
Access 2007
Use the Expression Builder
Article The Expression Builder is an advanced tool for creating expressions by picking items from lists. It requires some learning, but will save you time.
Access 2007
Create a control that references a control on another form
Article This article describes you how to add a text box control to a form, and then set the properties for that text box so that it displays a value from a control on ...
Access 2007
Combine text values by using an expression
Article When you want to combine the values in two or more text fields, you create an expression that uses the ampersand ( & ) operator. For example, suppose that you h...
Access 2007
Demo: Use the Expression Builder
Article See how to make "formulas" in Access with the Expression Builder. This video uses the DateDiff function in an expression to calculate a value on a report.
Access 2007
Access wildcard character reference
Article Note This topic provides reference information and limited how-to information for using the wildcard characters provided by Microsoft Office Access 2007 ...
Access 2007
Why does Access want me to enter a parameter value?
Article Learn why Access displays the Enter Parameter Value dialog box.
Access 2013
Didn't find what you were looking for?Search all of Office.com