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");
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");