Mega Code Archive

 

Categories / Delphi / ADO Database

 

Access crosstab queries queries

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];