Question and Answer Database FAQ4436B.txt — Access CrossTab queries queries Category :Database (MSACCESS) Platform :All-32Bit Product :All-CBuilder, BC++5.x, Delphi2.x, Delphi3.x, Delphi4.x, VdBase7.x, 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]; 3/26/99 10:33:03 AM
Last Modified: 01-SEP-99