????? ????? ??????? ????? ???????? ??? ???? ?????

?????? ????????? ?????? ?????????
???? ???????: 304458 - ??? ???????? ???? ????? ????? ??? ???????.
??????: ????? ????? ???????? ????? ? ???????? ??????? ??????? ????????.

??? ????? ??? ?????? ??? ??? ????? ?????? Microsoft Access (.accdb ? mdb.). ?????? ??? ????? Microsoft Access 2000 ?? ??? ???????? ???? 209143.
?????? ??? ????? Microsoft Access 97 ?? ??? ???????? ???? 109939.
????? ???? | ?? ????

??????

?? ??????? ????? Microsoft Access, ????? ????? ??? ???? ??? ?? ???? ????. ?? ???? ?? ????? ???? ?? ???? ????? ?? ?????????.

???? ?????? ?????? ?????? ?? ????????? ??? ???? ??? ??? ????? ? ??????? ?????????? ??? ???:
   Company Name  1998 Orders  1998 Total  1999 Orders  1999 Total
   --------------------------------------------------------------
   ABC Company   12           $855.00     15           $1010.25
   XYZ Company   1017         $22045.57   1050         $25345.29
				
???? ??? ????? ?? ??????? "??? ???? ??????" ??????? ?????????.

??????? ????

?????? ??????? ????? "??? ???? ??????" ??? ????? ??????? ????? ?????? ??? ???? ???? ????. ?? ????? ??????? ??????? ????? ??? ??????????? ???????? ??? ???? ??????? ???? ??????.

?????? ?????? ?????? ????? ????? ???????? Northwind.mdb ?????? ??????? ???? ????? ???? ?????? ?? ??? "??????" ?? ??? ???????. ?????? ??? "????????" ? "?????? ??? ??? ??? ????.
  1. ???? ????? ????? ???????? Northwind.mdb ?? ?? ?????? ??????? ????? ?????? ???? ????? ??? ???????? Order Details ???????? ???????:
       Query: Order Total
       ------------------
       Type: Crosstab Query
       Join: Customers.[CustomerID] <-> Orders.[CustomerID]
       Join: Orders.[OrderID] <-> Order Details.[OrderID]
    
       Field: CompanyName
          Table Name: Customers
          Total: Group By
          Crosstab: Row Heading
    
       Field: Expr1: Year([OrderDate]) & " " & "Order Total"
          Table Name:
          Total: Group By
          Crosstab: Column Heading
    
      Field: Expr2: Sum(CCur([UnitPrice]*[Quantity]*(1-[Discount])))
          Table Name:
          Total: Expression
          Crosstab: Value
    					
  2. ??? ??? ????????? ???? ????? ??????.
  3. ????? ??????? ????? ?????? ???? ????? ??? ????? ???????? ???????:
       Query: Order Count
       ------------------
       Type: Crosstab Query
       Join: Customers.[CustomerID] <-> Orders.[CustomerID]
    
       Field: CompanyName
          Table Name: Customers
          Total:      Group By
          Crosstab:   Row Heading
    
       Field: Expr1: Year([OrderDate]) & " " & "Order Count"
          Table Name:
          Total: Group By
          Crosstab: Column Heading
    
    
       Field: OrderID
          Table Name: Orders
          Total:      Count
          Crosstab:   Value
    					
  4. ???? ??? ????????? ??? ?????.
  5. ????? ??????? ????? ??? "?????? ?????" ??????????? ???????? ??? ?????. ?????? ?? CompanyName ?????? ????? ? Count ????? ?????? ??????? ??????? ???? ???? ?????. ?????? ?????? ?????? ??????? ??????? ????? ?? ?????? ????? ? Count ????? ?? Microsoft Access.
       Query: Multiple Values
       ----------------------
       Join: Order Total.[CompanyName] <-> Order Count.[CompanyName]
    
       Field: CompanyName
          Table Name: Order Count
    
       Field: 1997 Order Count
          Table Name: Order Count
    
       Field: 1997 Order Total
          Table Name: Order Total
    
       Field: 1998 Order Count
          Table Name: Order Count
    
       Field: 1998 Order Total
          Table Name: Order Total
    					
  6. ??? ????? ??????? "??? ??????" ???? ???? ???? ???? ??????? ??? ?????? ??????:
                             1997 Order  1997 Order  1998 Order  1998 Order
       Company Name            Count       Total       Count       Total
       --------------------------------------------------------------------
       Alfred's Futterkiste        3      $2,022.50        3      $2,022.50
       Ana Trujillo                2        $799.75        1        $514.10
       Antonio Moreno              5      $5,960.78        1        $660.00
    					
    ??????: ??? ???? ????? ??? ?????? ??? ??????? ??? ??? ????? ?????? ?? ????? ??? ?? ???? ?? ??? ??????? ????? ?? ?????????. ??? ???? ??????? ?? ?????? 1 ?? ?????:
       Year([OrderDate]) & " " & "Order Total"
    					
    ???:
       Year([Orders].[OrderDate]) & " " & "Order Total"
    					
    ??? ???? ??? ?????? ??? ?? ?????? ???? ???? ???? ?????? ??? ?? ???? ????. ??? ???? ??? ?????? ???? ???? ???? ?????? ??? ???? ????????.

?????

????? ?? ????????? ??? ??????????? ???????? ???? ??? ??????? Microsoft Access ?? ??????? ??????? ? ???? ??????????? ???????? ?? ????? Office "??" ????? ??????? ?? ???? ??? ??? ???? ???????? ???? ?? ???????.

???????

???? ???????: 304458 - ????? ??? ??????: 08/???? ?????/1428 - ??????: 6.0
????? ???
  • Microsoft Office Access 2007
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
????? ??????: 
kbmt kbquery kbhowto KB304458 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????304458

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com