& (ampersand)
concatenating expressions with, A40
concatenating fields or strings with, 362
displaying available characters in this position, 655
* (asterisk)
all fields indicator, 352, 507
designating next character as fill character, 653, 655
multiplying expressions with, 365
operator precedence for, 367
record indicator icon, 390
as wildcard, 169, 406, A49
\ (backslash)
operator precedence for, 367
rounding numeric expressions with, 365
used to display character immediately following, 653, 655
{} (brackets)
added to SELECT statements in earlier Access versions, A61
defining list of comparison characters in, A49
delimiting names for SQL Server, 1460, A26
displaying text in color specified, 654, 656
enclosing object name in, 372, 919
including query parameters in, 449
inserted automatically in form control reference, 901
placing around field names, 362
when to enclose names in, 989-989
^ (caret)
arithmetic operator, 365
operator precedence for, 367
testing character position in project file, A49
… (continuation indicator), 130
, (comma) as thousands separator, 653
$ (dollar sign) in format string, 653, 655
-- (double hyphens) for single line comments, 1528
<<(double left arrow) button, 593
" " (double quotation marks)
added to single text values, 355
embedding text with, 653, 655
placing delimited object names in, 1460
string constants with, 362
>> (double right arrow) button, 593
= (equal sign)
entering expressions after, 763
equal comparison, 168, 169
indicating equal joins, A42
! (exclamation mark)
forcing left alignment, 653, 655
not trusted macro actions marked with, 918
preceding object name with, 989-990
separating table and field names with, 372, 373
/ (forward slash)
dividing numeric expressions with, 365, 373
operator precedence for, 367
*/ (*forward slash), 1528
/* (forward slash*), 1528
>= (greater than or equal to sign)
comparing values with, 168, 169
returning query results with, 1503, A42
> (greater than sign)
comparing values with, 169
indicating uppercase characters, 655
returning query results with, 1503, A42
right arrow button, 593
<= (less than or equal to sign)
comparing values with, 168, 169
returning query results with, 1503, A42
< (less than sign)
comparing values with, 168, 169
indicating lowercase characters, 655
left arrow button removing fields from Selected Fields list, 593
returning query results with, 1503, A42
- (minus sign)
arithmetic operator, 365
as character in format string, 653, 655
operator precedence for, 367
() (parentheses)
adding to expressions, 370
as characters in format string, 653, 655
expression evaluation within, 367
scalar functions in, 1542
% (percentage sign)
multiplying value by 100 and including trailing percent sign, 654
wildcard character for project file, A49
. (period)
indicating decimal in numbers and currency, 653
rules for using with names, 990
separating table and field names with, 372, 373
@ placeholder character, 655
+ (plus sign)
adding expressions with, 365
as character in format string, 653, 655
concatenating project file expressions with, A40
expanding subdatasheets, 387–390, 461
operator precedence for, 367
# (pound sign)
placeholder character, 653
as wildcard, 169, A49
? (question mark) wildcard, 169, A49
' ' (single quotation marks), string constants with, 362
_ (underscore)
default placeholder character, 171
using names in brackets with embedded, 989
wildcard character for project file, A49
<> (unmatched) values, returning queries with, 1503, A42
0 placeholder character, 653
3-D object color, 565