Index

Symbols and Numbers

& (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