Use the SQL tab to create an SQL WHERE clause to handle selection criteria that are more complex than can be defined on the Selection Criteria tab. For example, to select the appropriate set of data for a table, you might need a combination of AND and OR logical operators.

Abbreviation for the table name in the Table box. Enter an easily typed substitute for the fully qualified table name to use in criteria or an SQL WHERE clause.
Character that is required to identify substitution variables in SQL WHERE clauses and selection criteria. To change the delimiter, click the down arrow.
Enter the SQL WHERE clause portion of the SELECT Statement.
A list of the columns in the table. Select a column name to add it to the SQL WHERE clause at the cursor position. You cannot search an SQL Variant column.
A list of valid operator symbols that you can use in the SQL WHERE clause. Select an operator symbol to insert it at the cursor position.
A list of valid operators that you can use in the SQL WHERE clause. Select an operator to insert it at the cursor position.
Use the BEFORE operator to select data based on date. The syntax for this operator is as follows:
colname BEFORE (nD nW nM nY)
The column that is referenced by colname must be a DATE column. Use the D, W, M, and Y arguments in any combination to indicate the number of days, weeks, months, or years that are subtracted from the date at run time. If no arguments are specified, the current date is used. Rows with a date in colname that is older than the calculated date are extracted or archived. The n multiplier is an integer and can optionally be preceded by + or -.
An SQL icon
in the Table Specifications
column on the Access Definition Editor table
list indicates that SQL WHERE clause specifications apply for the
table.