Yes. Here is an example created by using the Crosstab expert from Access against the Northwind sample database.

TRANSFORM Count([OrderID]) AS [The Value] SELECT [ShipVia], Count([OrderID]) AS [Total Of OrderID] FROM Orders GROUP BY [ShipVia] PIVOT [ShipPostalCode];

3/26/99 0:33:03 AM