Multiple Columns in Crosstabs

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

A couple days ago I needed to sum currency values and count the number of
contributions to the values. I created an intermediate pair of crosstabs and
created a report with them.

I am finding now that I can just keep addending Row Headings to a primary
query created with the Crosstab Wizard.

Is there a limit to this or is it just basic SQL? The Wizard allows only
three Row Headings but not the same one.

LDN

Example using Northwind...
TRANSFORM Sum(Invoices.ExtendedPrice) AS SumOfExtendedPrice
SELECT Invoices.Country, Sum(Invoices.ExtendedPrice) AS [Total Of
ExtendedPrice], Count(Invoices.ExtendedPrice) AS [Count Of ExtendedPrice],
Max(Invoices.ExtendedPrice) AS [Max], Min(Invoices.ExtendedPrice) AS [Min]
FROM Invoices
GROUP BY Invoices.Country
PIVOT Format([OrderDate],"yyyy");
 
The wizard has limits but modifying the query in design view allows many
more. I seem to recall a limit of about 20 group by fields but this could be
very wrong.
 
Back
Top