, . , , , .
, .
, , , . :
1. "" (Products), "" (Orders) "" (Order Details).
2. "" (ProductID) "" (ProductName) "", "" (OrderedDate) "", .
3. , (Query, Crosstab Query). 1: (Select Query: Queryl) 1: (Crosstab Query: Queryl). , (Crosstab) (Total), (Group By).
4. "" (Row Heading). "". ֳ .
5. "" . <=#31.12.97#And>=#01.01.97# 1997 .
() :
: Sum([ʳ]*[].[ֳ])
, , . , " ". , , , , . , , , . , . "ֳ" ' "", "ʳ" . ' , ' "ֳ" "" "". , Access , , , 1.
(Expression), (Value). " " , . "" ', (Ambiguous field reference).
|
|
() format [ ]; "mmm"). Format() "". , , , Access ' "" (Exprl). , ' . (Column Heading) (.2). , , .
8. . ' , . 3.
, : , . ֳ . .