ACC2002: Error When You Sort on a Column in a Crosstab Query (275070)

MORE INFORMATION

Steps to Reproduce the Behavior

1. Open the Northwind sample database.
2. Create a new query, and then enter the following SQL statement in SQL view of the query:

   TRANSFORM Sum([Order Details].[UnitPrice]*[Order Details].[Quantity]) AS SumOfOrderItem
   SELECT Products.CategoryID, Customers.CustomerID
   FROM (Customers INNER JOIN Orders ON Customers.CustomerID =
   Orders.CustomerID) INNER JOIN (Products INNER JOIN [Order Details] ON
   Products.ProductID = [Order Details].ProductID) ON Orders.OrderID = [Order
   Details].OrderID
   WHERE (((Products.ProductID)<20))
   GROUP BY Products.CategoryID, Customers.CustomerID, Products.ProductName
   ORDER BY Products.CategoryID, Customers.CustomerID
   PIVOT Products.ProductName;
   					

3. Save the query as qryCrosstab, and then close it.
4. Open the qryCrosstab query in Datasheet View.
5. Click the heading of the CustomerID column, and then on the Records menu, point to Sort, and click Sort Ascending. Note that the records are now sorted by CustomerID.
6. Switch the query to Design View, and then switch back to Datasheet View. Note that the query is no longer sorted by CustomerID.
7. Click the heading of the CustomerID column again, and then on the Records menu, point to Sort, and click Sort Ascending. Note that you receive the error message that is mentioned in the "Symptoms" section of this article.