Question:
Can the BDE MSACCESS driver execute crosstab queries?
Answer:
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];