ACC: ????? ??????? ????? ?????? ?????? ??????

?????? ????????? ?????? ?????????
???? ???????: 109939 - ??? ???????? ???? ????? ????? ??? ???????.
???????: ????? ????? ????? ???????? ??? ????? ????????? ???????? ??????.

????? ???? | ?? ????

?? ??? ??????

??????

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

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

??????: ???? ?????? ????? ?????? ??????? ????????? ?? ??? ??????? ?? ????? ??? Qrysmp97.exe. ?????? ??? ??????? ??? ????? ?????? ??? ??? ????? ????? ?????? ?????? ??????? ??????? ?? "????? ??????? ?? Microsoft:
182568ACC97: Microsoft Access 97 ????? ????????? ???????? ?? ???? ???????

??????? ????

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

?????? ?????? ?????? ?? ????? ????? ???????? Northwind.mdb ?? Microsoft Access ??????? 7.0 ? Microsoft Access 97 (?? NWIND.MDB ?? ????????? ??????? ?? 2.0) ??? ????? ??????? ???? ????? ???? ?????? ?????? ???? ??? ???????? ?????? ??? ??? ??? ????.

?????? ??????: ????? ??????? ????? ????? ????????

?????? ????????? "??????? ?????? ?????" ???? ??????? ???????:
  1. ???? ????? ????? ???????? Northwind.mdb (?? NWIND.MDB ?? ??????? 2.0 ?? ????? ????) ??? ?????? ????????? ??????? ?????? ???????? ??? ???????? Order Details ???????? ???????.
          Query: Order Total
          ------------------
          Type: Crosstab Query
          Join: Customers.[CustomerID] <-> Orders.[CustomerID]
    
          NOTE: In versions 1.x and 2.0, there is a space in Customer ID.
    
          Join: Orders.[OrderID] <-> Order Details.[OrderID]
    
          NOTE: In versions 1.x and 2.0, there is a space in Order ID.
    
          Field: CompanyName
             Table Name: Customers
             Total: Group By
             Crosstab: Row Heading
    
          NOTE: In versions 1.x and 2.0, there is a space in Company Name.
    
          Field: Expr1: Year([OrderDate]) & " " & "Order Total"
             Table Name:
             Total: Group By
             Crosstab: Column Heading
    
          NOTE: In versions 1.x and 2.0, there is a space in Order Date.
    
          Field: Expr2: Sum(CCur([UnitPrice]*[Quantity]*(1.-[Discount])))
             Table Name:
             Total: Expression
             Crosstab: Value
    
          NOTE: In versions 1.x and 2.0, there is a space in Unit Price.
    					
  2. ??? ????????? ?????? ????? ??? ?? ???? ??? ??????? ???????? ?? ????? ?????? ?? ???? ????? ?????????. ???? ??? "????? ?????????" ?? ??????? ??? ???? ???? ???????? "?????? ??????? ???????" ?? ?????? "?????? ??????? ???????" ???? ????????? ?????? ?? ??????? ?? Microsoft Access:
          Version 1.x:      "1989 Order Total";"1990 Order Total";"1991 Order
                            Total";"1992 Order Total"
    
          Version 2.0:      "1991 Order Total";"1992 Order Total";"1993 Order
                            Total";"1994 Order Total"
    
          Version 7.0:      "1993 Order Total";"1994 Order Total";"1995 Order
                            Total"
    
          Version 97:       "1994 Order Total";"1995 Order Total";"1996 Order
                            Total"
    					
??????: ?? ??????? Microsoft Access 2.0 ? 7.0 ? 97, ??????? FixedColumnHeadings ???? "?????? ???????".

?????? ??????: ????? ??????? ????? ??? ?????

  1. ????? ??????? ????? ?????? ???????? ??? ????? ???????? ???????:
          Query: Order Count
          ------------------
          Type: Crosstab Query
          Join: Customers.[CustomerID] <-> Orders.[CustomerID]
    
          NOTE: In versions 1.x and 2.0, there is a space in Customer ID.
    
          Field: CompanyName
             Table Name: Customers
             Total:      Group By
             Crosstab:   Row Heading
    
          NOTE: In versions 1.x and 2.0, there is a space in Company Name.
    
          Field: Expr1: Year([OrderDate]) & " " & "Order Count"
             Table Name:
             Total: Group By
             Crosstab: Column Heading
    
          NOTE: In versions 1.x and 2.0, there is a space in Order Date.
    
          Field: OrderID
             Table Name: Orders
             Total:      Count
             Crosstab:   Value
    
          NOTE: In versions 1.x and 2.0, there is a space in Order ID.
    					
  2. ??? ????????? ?????? ????? ??? ?? ???? ??? ??????? ???????? ?? ????? ?????? ?? ???? ????? ?????????. ???? ??? "????? ?????????" ?? ??????? ??? ???? ???? ???????? "?????? ??????? ???????" ?? ?????? "?????? ??????? ???????" ???? ????????? ?????? ?? ??????? ?? Microsoft Access:
          Version 1.x:      "1989 Order Count";"1990 Order Count";"1991 Order
                            Count";"1992 Order Count"
    
          Version 2.0:      "1991 Order Count";"1992 Order Count";"1993 Order
                            Count";"1994 Order Count"
    
          Version 7.0:      "1993 Order Count";"1994 Order Count";"1995 Order
                            Count"
    
          Version 97:       "1994 Order Count";"1995 Order Count";"1996 Order
                            Count"
    					
??????: ?? ??????? Microsoft Access 2.0, 7.0 ? 97, ??????? FixedColumnHeadings ???? "?????? ???????".

?????? ????: ????? ??????? ??? ??????

  1. ????? ??????? ????? ???????? ??? "????? ??????" ??? ????? ????????? ?????. ???? ??????? CompanyName ???????? ??? ???? ???????? ????? ? Count ????? ??????? ??????? ???? ???? ?????. ?????? ?????? ?????? ??????? ??????? ????? ?? ?????? ????? ? Count ????? ?? Microsoft Access 97.
          Query: Multiple Values
          ----------------------
          Join: Order Total.[CompanyName] <-> Order Count.[CompanyName]
    
          NOTE: In versions 1.x and 2.0, there is a space in Company Name.
    
          Field: CompanyName
             Table Name: Order Count
             Show: Yes
          Field: 1995 Order Count
             Table Name: Order Count
             Show: Yes
          Field: 1995 Order Total
             Table Name: Order Total
             Show: Yes
          Field: 1996 Order Count
             Table Name: Order Count
             Show: Yes
          Field: 1996 Order Total
             Table Name: Order Total
             Show: Yes
    					
????? ??????? "??? ??????" ????? ?? ???? ???? ??????:
 Company Name          1995 Order Count 1995 Order Total 1996 Order Count..
 --------------------------------------------------------------------------
 Alfred's Futterkiste  3                $2,022.50        3
 Ana Trujillo          2                  $799.75        1
 Antonio Moreno        5                $5,960.78        1
				

??????: ??? ??????? ?? ???? ??? ?? ????? ????? ????? (One(expr1)) ?????? ??? ?? ???? ?? ??? ??????? ???????? ?? ?????????. ???? ????? ?????? ????????? ???? ??? ?????? ?? ??????? ??? ????? ??? ?????-1310. ??? ??? ?????? ??? ?????? ??? ?? ?????? ????? ??? ?? ???? ????. ??? ???? ??? ?????? ???? ???? ???? ?????? ??? "???? ??????".

?????

????? ?? ????????? ??? ??????????? ???????? ????? ?? "??????????? ???????? ????? ?" ??? ?? "????? ??????? ????? ???? ??????? ????? ?" ???????? ???? ????????? ????? ?? Microsoft Access 97.

???????

???? ???????: 109939 - ????? ??? ??????: 28/?? ?????/1427 - ??????: 2.1
????? ???
  • Microsoft Access 1.0 Standard Edition
  • Microsoft Access 1.1 Standard Edition
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
????? ??????: 
kbmt kbinfo KB109939 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????109939
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

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