, . . , , . , ( ) .
:
- , .
- , , . 8.
(. 8)
- .
- .
, : , , ., .
:
- . :
- (+);
- (*);
- (-);
- (/);
- (\).
, , .
- . . (True, False, Null). :
- (>);
- (>=);
- (<);
- (<=);
- (<>).
- () . True, False, Null. :
- (And);
- (Or);
- (Not);
- (Xor).
, Not, .
- . . : &.
- . Access :!( ) . (). , , . ! , : ! . . , : ! ..
- . SQL, Like, ls, ln, Between.. And, .
- ls. ls Null ls not Null. .
- Like. , . : *( ),? ( ), # ( ), [] ( ), [!] ( , ).
- ln. , , . ln(, ). , .
- Between And. , , , Between #01--1995# And #01--1996#.
|
|
. MS Access . :
- . , ( ), - . , 3,4567E-01, 120, -23.
- . (-, A-Z), 0 9, , . , , . .
- . Access # , , Access , .
. Access , . :
( )
o Date(). ..;
o DateAdd(d,-15,[]). , 15 .
o Datediff(d,[],[]). .
o Year(#12.06.08#). , .. 2008.
o Format (Date, dd-mmm-yyyy). , .
o LnStr(Ĕ,Д). , .
o LCase(Ĕ). .
o Val(12,34) 12,34 12,34
o Str(123,6) 123,6 123,6
( )
.
: , 1 2007 . 1 2008 . . SQL: Between And. .
, . ( , , , ). : Between #01.12.2007# And #01.01.2008#. .
: , ϻ .
, . . , . 9:
(. 9)
.
: , ϻ .
, . . , . 10:
|
|
(. 10)
.
: , : , 200 ., , 100 . .
, . . , . 11:
(. 11)
.