, . . SQL.
, , , Access, . .
Access , . , . , , , . " " .
. , , . < >. . 4.4 .
4.4.
<100 | 100 | |
>0 | 0 | |
< >42 | , 42 | |
<=100 | 100 | |
0 | ||
=42 | 42. ( -?) | |
Between 0 and 100 | 0,100 |
, , , . , , . >Jan 30, 2007 (> 30 , 2007), Access , . . , (Jan 30, 2 007) . , >1/30/07, Access , .
Access, : #1/30/2007#
// #. , >#1/30/2007#, ,
|
|
( ), January 30, 2007 (30 2007 January 31, 2007 , 2006 . .
, : #1/30/2007 5:30#
Access . #1/30/2007# , . Access , #1/30/2007 8:00 # , 8 .
, , , . :
■ Date () ( - ,
);
■ Now () , .
, - , . . " " 7 , , , .
. 4.5 .
4.5.
<#1/30/2007# | 30 2007 . | |
>#1/30/2007 5:30 # | 30 2007 ., 30 2007 . 17:30 | |
<=#1/30/2007# | 30 2007 . 30 2007 . | |
>=#1/30/2007# | 30 2007 . | |
>Date() | ||
<Date() | ||
( ) | >Now() | |
( ) | <Now () |