Главная страница | назад

Article #19436: Access CrossTab queries queries

 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,   

Can the BDE MSACCESS driver execute crosstab queries?

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