, . 7.2. . FormatCurrency(), FormatPercent () FormatNumber () ( , ). , , , .
, , , Format (). , Access (. . 7.6).
Access , . Round () Format () (. 7.3), Access .
7.3.
Sqr () | Sqr(9) | ||
Abs() | ( ) | Abs(-6) | |
Round () | Round(8.89, 1) | 3.9 | |
Fix () | , | Fix(8.89) | |
Int() | Fix(), , | Int(-8.89) | -9 |
7.3. ()
Rnd() | 0 1 | Int ((6) * Rnd + 1) | 1 6 |
Val () | , . , , 0, | Val ("315 Crossland St") | |
Format() | Format(243.6, Currency) | $243.60 |
.
Rnd () , , ? Access Rnd (). , , .
, . , Random: Rnd (). , 0 1 (, 0.7045, 0.2344 . .) .
|
|
, Random . ( ) . --! , , Access .
, , . . .
■ . . &, . " " .
. , 100 .
■ . , .
. 7.4 , .
7.4.
UCase() | UCase("Hi There") | HI THERE | |
LCase() | LCase("Hi There") | hi there | |
Left () | , | Left("Hi There", 2) | Hi |
Right 0 | , | Right ("Hi There", 5) | There |
Mid () | , , | Mid ("Hi There", 4, 2) | Th |
Trim () | ( LTrim () RTrim() ) | Trim(" Hi There ") | Hi There |
Len () | Len("Hi There") |
, ( ). . , , . , , "Choco": Left([ProductName], 5) = "Choco"
. 7.7 , .
Len () . ( , , , ). , . . . , , , , Description 15 .
|
|
Len{Description) < 15